Pandas Profiling Report

Dataset statistics

Number of variables	50
Number of observations	237805
Missing cells	952069
Missing cells (%)	8.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	92.5 MiB
Average record size in memory	408.0 B

Variable types

Text	4
Numeric	18
Categorical	21
DateTime	5
Unsupported	2

Alerts

`Valor del Contrato` is highly overall correlated with `Valor Pendiente de Pago` and 2 other fields	High correlation
`Valor de pago adelantado` is highly overall correlated with `Valor Pendiente de Amortizacion`	High correlation
`Valor Facturado` is highly overall correlated with `Valor Pagado`	High correlation
`Valor Pendiente de Pago` is highly overall correlated with `Valor del Contrato` and 2 other fields	High correlation
`Valor Pagado` is highly overall correlated with `Valor Facturado` and 2 other fields	High correlation
`Valor Pendiente de Amortizacion` is highly overall correlated with `Valor de pago adelantado`	High correlation
`Valor Pendiente de Ejecucion` is highly overall correlated with `Valor del Contrato` and 2 other fields	High correlation
`Saldo CDP` is highly overall correlated with `Valor del Contrato`	High correlation
`Orden` is highly overall correlated with `Sector`	High correlation
`Sector` is highly overall correlated with `Orden`	High correlation
`Tipo de Contrato` is highly overall correlated with `Modalidad de Contratacion`	High correlation
`Modalidad de Contratacion` is highly overall correlated with `Tipo de Contrato` and 1 other fields	High correlation
`Es Grupo` is highly overall correlated with `Modalidad de Contratacion`	High correlation
`EsPostConflicto` is highly overall correlated with `Destino Gasto`	High correlation
`Destino Gasto` is highly overall correlated with `EsPostConflicto`	High correlation
`Rama` is highly imbalanced (61.3%)	Imbalance
`Tipo de Contrato` is highly imbalanced (80.3%)	Imbalance
`Modalidad de Contratacion` is highly imbalanced (72.1%)	Imbalance
`Condiciones de Entrega` is highly imbalanced (53.2%)	Imbalance
`TipoDocProveedor` is highly imbalanced (79.1%)	Imbalance
`Es Grupo` is highly imbalanced (95.0%)	Imbalance
`Habilita Pago Adelantado` is highly imbalanced (97.4%)	Imbalance
`Liquidación` is highly imbalanced (52.1%)	Imbalance
`Obligación Ambiental` is highly imbalanced (83.8%)	Imbalance
`Obligaciones Postconsumo` is highly imbalanced (99.5%)	Imbalance
`Reversion` is highly imbalanced (99.9%)	Imbalance
`EsPostConflicto` is highly imbalanced (94.9%)	Imbalance
`Fecha de Inicio de Ejecucion` has 237798 (> 99.9%) missing values	Missing
`Fecha de Fin de Ejecucion` has 237798 (> 99.9%) missing values	Missing
`Fecha Inicio Liquidacion` has 237805 (100.0%) missing values	Missing
`Fecha Fin Liquidacion` has 237805 (100.0%) missing values	Missing
`Valor del Contrato` is highly skewed (γ1 = 487.5652228)	Skewed
`Valor de pago adelantado` is highly skewed (γ1 = 268.3515114)	Skewed
`Valor Facturado` is highly skewed (γ1 = 262.2819222)	Skewed
`Valor Pendiente de Pago` is highly skewed (γ1 = 160.9699943)	Skewed
`Valor Pagado` is highly skewed (γ1 = 281.631663)	Skewed
`Valor Amortizado` is highly skewed (γ1 = 221.5055293)	Skewed
`Valor Pendiente de Amortizacion` is highly skewed (γ1 = 269.8545923)	Skewed
`Valor Pendiente de Ejecucion` is highly skewed (γ1 = 160.7827879)	Skewed
`Saldo CDP` is highly skewed (γ1 = 487.4634854)	Skewed
`Saldo Vigencia` is highly skewed (γ1 = 54.94188551)	Skewed
`Dias Adicionados` is highly skewed (γ1 = 486.8615327)	Skewed
`Presupuesto General de la Nacion – PGN` is highly skewed (γ1 = 225.6755301)	Skewed
`Sistema General de Participaciones` is highly skewed (γ1 = 167.4845626)	Skewed
`Sistema General de Regalías` is highly skewed (γ1 = 138.5649022)	Skewed
`Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)` is highly skewed (γ1 = 487.6382423)	Skewed
`Recursos de Credito` is highly skewed (γ1 = 159.5573664)	Skewed
`Recursos Propios` is highly skewed (γ1 = 137.3734988)	Skewed
`Fecha Inicio Liquidacion` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Fecha Fin Liquidacion` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Valor de pago adelantado` has 237635 (99.9%) zeros	Zeros
`Valor Facturado` has 114088 (48.0%) zeros	Zeros
`Valor Pendiente de Pago` has 44489 (18.7%) zeros	Zeros
`Valor Pagado` has 144403 (60.7%) zeros	Zeros
`Valor Amortizado` has 237779 (> 99.9%) zeros	Zeros
`Valor Pendiente de Amortizacion` has 237652 (99.9%) zeros	Zeros
`Valor Pendiente de Ejecucion` has 43569 (18.3%) zeros	Zeros
`Saldo CDP` has 15160 (6.4%) zeros	Zeros
`Saldo Vigencia` has 234044 (98.4%) zeros	Zeros
`Dias Adicionados` has 203441 (85.5%) zeros	Zeros
`Presupuesto General de la Nacion – PGN` has 186497 (78.4%) zeros	Zeros
`Sistema General de Participaciones` has 226862 (95.4%) zeros	Zeros
`Sistema General de Regalías` has 235635 (99.1%) zeros	Zeros
`Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)` has 116337 (48.9%) zeros	Zeros
`Recursos de Credito` has 237029 (99.7%) zeros	Zeros
`Recursos Propios` has 185428 (78.0%) zeros	Zeros

Reproduction

Analysis started	2023-07-15 23:30:15.997334
Analysis finished	2023-07-15 23:36:09.441765
Duration	5 minutes and 53.44 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

Nombre Entidad
Text

Distinct	2604
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Length

Max length	136
Median length	99
Mean length	40.682782
Min length	3

Characters and Unicode

Total characters	9674569
Distinct characters	78
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	402 ?
Unique (%)	0.2%

Sample

1st row	UNIDAD EJECUTORA DE SANEAMIENTO DEL VALLE DEL CAUCA
2nd row	Secretaría de Gobierno Convivencia y Seguridad Alcaldía de Tuluá
3rd row	SECRETARIA DISTRITAL DE AMBIENTE
4th row	GOBERNACIÓN DEL DEPARTAMENTO ARCHIPIELAGO DE SAN ANDRES PROVIDENCIA Y SANTA CATALINA
5th row	ALCALDIA MUNICIPAL DE MELGAR

Value	Count	Frequency (%)
de	221734	16.5%
del	50317	3.8%
y	37845	2.8%
municipio	36631	2.7%
instituto	25988	1.9%
la	24766	1.8%
regional	23097	1.7%
alcaldia	18842	1.4%
distrital	17759	1.3%
departamento	16464	1.2%
Other values (2212)	868244	64.7%

Most occurring characters

Value	Count	Frequency (%)
	1135290	11.7%
A	1040244	10.8%
E	874467	9.0%
I	854270	8.8%
N	548188	5.7%
D	546468	5.6%
O	546056	5.6%
R	530101	5.5%
T	473040	4.9%
C	472346	4.9%
Other values (68)	2654099	27.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	7923124	81.9%
Space Separator	1135290	11.7%
Lowercase Letter	610790	6.3%
Decimal Number	5365	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1040244	13.1%
E	874467	11.0%
I	854270	10.8%
N	548188	6.9%
D	546468	6.9%
O	546056	6.9%
R	530101	6.7%
T	473040	6.0%
C	472346	6.0%
L	447400	5.6%
Other values (26)	1590544	20.1%

Lowercase Letter

Value	Count	Frequency (%)
i	75784	12.4%
o	60082	9.8%
r	59732	9.8%
a	59325	9.7%
t	59238	9.7%
e	48801	8.0%
n	41076	6.7%
d	32278	5.3%
c	26577	4.4%
s	25446	4.2%
Other values (21)	122451	20.0%

Decimal Number

Value	Count	Frequency (%)
1	3710	69.2%
2	549	10.2%
6	280	5.2%
4	244	4.5%
3	187	3.5%
8	121	2.3%
5	89	1.7%
7	72	1.3%
9	70	1.3%
0	43	0.8%

Space Separator

Value	Count	Frequency (%)
	1135290	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8533914	88.2%
Common	1140655	11.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1040244	12.2%
E	874467	10.2%
I	854270	10.0%
N	548188	6.4%
D	546468	6.4%
O	546056	6.4%
R	530101	6.2%
T	473040	5.5%
C	472346	5.5%
L	447400	5.2%
Other values (57)	2201334	25.8%

Common

Value	Count	Frequency (%)
	1135290	99.5%
1	3710	0.3%
2	549	< 0.1%
6	280	< 0.1%
4	244	< 0.1%
3	187	< 0.1%
8	121	< 0.1%
5	89	< 0.1%
7	72	< 0.1%
9	70	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9594599	99.2%
None	79970	0.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1135290	11.8%
A	1040244	10.8%
E	874467	9.1%
I	854270	8.9%
N	548188	5.7%
D	546468	5.7%
O	546056	5.7%
R	530101	5.5%
T	473040	4.9%
C	472346	4.9%
Other values (51)	2574129	26.8%

None

Value	Count	Frequency (%)
Ó	29663	37.1%
Í	19527	24.4%
ó	8201	10.3%
í	5754	7.2%
Ñ	5366	6.7%
Á	5285	6.6%
Ú	1806	2.3%
Ò	1446	1.8%
á	1210	1.5%
É	883	1.1%
Other values (7)	829	1.0%

Nit Entidad
Real number (ℝ)

Distinct	2220
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6276754 × 10⁹

Minimum	90106609
Maximum	9.0162899 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	90106609
5-th percentile	8.0010393 × 10⁸
Q1	8.6050617 × 10⁸
median	8.9138004 × 10⁸
Q3	8.9999924 × 10⁸
95-th percentile	8.9200015 × 10⁹
Maximum	9.0162899 × 10⁹
Range	8.9261833 × 10⁹
Interquartile range (IQR)	39493069

Descriptive statistics

Standard deviation	2.3246916 × 10⁹
Coefficient of variation (CV)	1.428228
Kurtosis	5.633006
Mean	1.6276754 × 10⁹
Median Absolute Deviation (MAD)	8619201
Skewness	2.7575802
Sum	3.8706934 × 10¹⁴
Variance	5.4041911 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
899999034	13475	5.7%
890399011	9453	4.0%
899999061	7871	3.3%
8999990619	6074	2.6%
899999239	3972	1.7%
900959048	2611	1.1%
900971006	2499	1.1%
9009585649	2179	0.9%
891480030	2110	0.9%
890480184	1994	0.8%
Other values (2210)	185567	78.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
90106609	8	< 0.1%
800000118	87	< 0.1%
800002916	27	< 0.1%
800003253	2	< 0.1%
800003935	118	< 0.1%
800004574	1	< 0.1%
800005042	4	< 0.1%
800005349	1	< 0.1%
800006095	1	< 0.1%
800007652	151	0.1%

Value	Count	Frequency (%)
9016289940	8	< 0.1%
9015500212	2	< 0.1%
9015425882	6	< 0.1%
9015425732	21	< 0.1%
9015412568	70	< 0.1%
9015411545	81	< 0.1%
9015410214	161	0.1%
9014531831	17	< 0.1%
9014427611	10	< 0.1%
9014332637	24	< 0.1%

Departamento
Categorical

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Distrito Capital de Bogotá	73300
Valle del Cauca	26378
Antioquia	23924
Santander	13418
Cundinamarca	11369
Other values (29)	89416

Length

Max length	40
Median length	26
Mean length	14.841841
Min length	4

Characters and Unicode

Total characters	3529464
Distinct characters	45
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Valle del Cauca
2nd row	Valle del Cauca
3rd row	Distrito Capital de Bogotá
4th row	San Andrés, Providencia y Santa Catalina
5th row	Tolima

Common Values

Value	Count	Frequency (%)
Distrito Capital de Bogotá	73300	30.8%
Valle del Cauca	26378	11.1%
Antioquia	23924	10.1%
Santander	13418	5.6%
Cundinamarca	11369	4.8%
Atlántico	8201	3.4%
Tolima	6955	2.9%
Norte de Santander	6802	2.9%
Bolívar	6479	2.7%
Meta	6279	2.6%
Other values (24)	54700	23.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	80102	14.9%
distrito	73300	13.6%
capital	73300	13.6%
bogotá	73300	13.6%
cauca	29888	5.6%
valle	26378	4.9%
del	26378	4.9%
antioquia	23924	4.4%
santander	20220	3.8%
cundinamarca	11369	2.1%
Other values (35)	99509	18.5%

Most occurring characters

Value	Count	Frequency (%)
a	438012	12.4%
t	374039	10.6%
i	323723	9.2%
	299863	8.5%
o	295632	8.4%
l	193086	5.5%
e	181642	5.1%
d	164007	4.6%
r	144356	4.1%
C	130538	3.7%
Other values (35)	984566	27.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2798413	79.3%
Uppercase Letter	428852	12.2%
Space Separator	299863	8.5%
Other Punctuation	2336	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	438012	15.7%
t	374039	13.4%
i	323723	11.6%
o	295632	10.6%
l	193086	6.9%
e	181642	6.5%
d	164007	5.9%
r	144356	5.2%
n	119651	4.3%
s	91169	3.3%
Other values (18)	473096	16.9%

Uppercase Letter

Value	Count	Frequency (%)
C	130538	30.4%
B	85232	19.9%
D	74191	17.3%
A	35732	8.3%
S	27221	6.3%
V	26968	6.3%
N	11667	2.7%
M	9344	2.2%
T	6955	1.6%
R	5547	1.3%
Other values (5)	15457	3.6%

Space Separator

Value	Count	Frequency (%)
	299863	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	2336	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3227265	91.4%
Common	302199	8.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	438012	13.6%
t	374039	11.6%
i	323723	10.0%
o	295632	9.2%
l	193086	6.0%
e	181642	5.6%
d	164007	5.1%
r	144356	4.5%
C	130538	4.0%
n	119651	3.7%
Other values (33)	862579	26.7%

Common

Value	Count	Frequency (%)
	299863	99.2%
,	2336	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3420301	96.9%
None	109163	3.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	438012	12.8%
t	374039	10.9%
i	323723	9.5%
	299863	8.8%
o	295632	8.6%
l	193086	5.6%
e	181642	5.3%
d	164007	4.8%
r	144356	4.2%
C	130538	3.8%
Other values (30)	875403	25.6%

None

Value	Count	Frequency (%)
á	88017	80.6%
í	11973	11.0%
ñ	3974	3.6%
ó	2800	2.6%
é	2399	2.2%

Ciudad
Text

Distinct	540
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Length

Max length	27
Median length	22
Mean length	8.1586888
Min length	3

Characters and Unicode

Total characters	1940177
Distinct characters	54
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	91 ?
Unique (%)	< 0.1%

Sample

1st row	Cali
2nd row	Tuluá
3rd row	Bogotá
4th row	San Andrés
5th row	Melgar

Value	Count	Frequency (%)
no	46729	15.3%
definido	46729	15.3%
bogotá	43093	14.2%
cali	17943	5.9%
medellín	10893	3.6%
barranquilla	6007	2.0%
bucaramanga	5959	2.0%
cúcuta	4653	1.5%
villavicencio	4526	1.5%
san	4247	1.4%
Other values (554)	113705	37.3%

Most occurring characters

Value	Count	Frequency (%)
o	231953	12.0%
a	214789	11.1%
i	174216	9.0%
e	127076	6.5%
n	119691	6.2%
l	95470	4.9%
t	77050	4.0%
d	76798	4.0%
r	73042	3.8%
	66679	3.4%
Other values (44)	683413	35.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1569014	80.9%
Uppercase Letter	304484	15.7%
Space Separator	66679	3.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	231953	14.8%
a	214789	13.7%
i	174216	11.1%
e	127076	8.1%
n	119691	7.6%
l	95470	6.1%
t	77050	4.9%
d	76798	4.9%
r	73042	4.7%
g	65004	4.1%
Other values (20)	313925	20.0%

Uppercase Letter

Value	Count	Frequency (%)
B	58392	19.2%
D	52192	17.1%
N	49266	16.2%
C	34771	11.4%
M	20782	6.8%
S	16769	5.5%
P	16532	5.4%
A	9634	3.2%
V	8144	2.7%
T	6858	2.3%
Other values (13)	31144	10.2%

Space Separator

Value	Count	Frequency (%)
	66679	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1873498	96.6%
Common	66679	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	231953	12.4%
a	214789	11.5%
i	174216	9.3%
e	127076	6.8%
n	119691	6.4%
l	95470	5.1%
t	77050	4.1%
d	76798	4.1%
r	73042	3.9%
g	65004	3.5%
Other values (43)	618409	33.0%

Common

Value	Count	Frequency (%)
	66679	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1857631	95.7%
None	82546	4.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	231953	12.5%
a	214789	11.6%
i	174216	9.4%
e	127076	6.8%
n	119691	6.4%
l	95470	5.1%
t	77050	4.1%
d	76798	4.1%
r	73042	3.9%
	66679	3.6%
Other values (37)	600867	32.3%

None

Value	Count	Frequency (%)
á	51172	62.0%
í	15538	18.8%
é	6649	8.1%
ú	4832	5.9%
ó	3304	4.0%
ñ	1042	1.3%
ü	9	< 0.1%

Localización
Text

Distinct	651
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Length

Max length	65
Median length	51
Mean length	28.998322
Min length	8

Characters and Unicode

Total characters	6895946
Distinct characters	55
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	109 ?
Unique (%)	< 0.1%

Sample

1st row	Colombia, Valle del Cauca , Cali
2nd row	Colombia, Valle del Cauca , Tuluá
3rd row	Colombia, Bogotá, Bogotá
4th row	Colombia, San Andrés, Providencia y Santa Catalina , San Andrés
5th row	Colombia, Tolima , Melgar

Value	Count	Frequency (%)
colombia	238050	25.6%
bogotá	146600	15.8%
	132927	14.3%
cauca	29888	3.2%
del	27114	2.9%
valle	26397	2.8%
antioquia	24000	2.6%
santander	20233	2.2%
cali	17943	1.9%
cundinamarca	11369	1.2%
Other values (572)	253698	27.3%

Most occurring characters

Value	Count	Frequency (%)
	971527	14.1%
o	895304	13.0%
a	744128	10.8%
,	460511	6.7%
l	453124	6.6%
i	420456	6.1%
C	329736	4.8%
m	274049	4.0%
t	261444	3.8%
b	253877	3.7%
Other values (45)	1831790	26.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4704273	68.2%
Space Separator	971527	14.1%
Uppercase Letter	759635	11.0%
Other Punctuation	460511	6.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	895304	19.0%
a	744128	15.8%
l	453124	9.6%
i	420456	8.9%
m	274049	5.8%
t	261444	5.6%
b	253877	5.4%
n	191975	4.1%
e	188363	4.0%
g	171576	3.6%
Other values (20)	849977	18.1%

Uppercase Letter

Value	Count	Frequency (%)
C	329736	43.4%
B	173831	22.9%
A	45366	6.0%
S	43990	5.8%
V	35112	4.6%
M	30182	4.0%
P	20345	2.7%
T	13813	1.8%
N	13399	1.8%
R	8862	1.2%
Other values (13)	44999	5.9%

Space Separator

Value	Count	Frequency (%)
	971527	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	460511	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5463908	79.2%
Common	1432038	20.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	895304	16.4%
a	744128	13.6%
l	453124	8.3%
i	420456	7.7%
C	329736	6.0%
m	274049	5.0%
t	261444	4.8%
b	253877	4.6%
n	191975	3.5%
e	188363	3.4%
Other values (43)	1451452	26.6%

Common

Value	Count	Frequency (%)
	971527	67.8%
,	460511	32.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6674116	96.8%
None	221830	3.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	971527	14.6%
o	895304	13.4%
a	744128	11.1%
,	460511	6.9%
l	453124	6.8%
i	420456	6.3%
C	329736	4.9%
m	274049	4.1%
t	261444	3.9%
b	253877	3.8%
Other values (38)	1609960	24.1%

None

Value	Count	Frequency (%)
á	169396	76.4%
í	27425	12.4%
é	9048	4.1%
ó	6104	2.8%
ñ	5016	2.3%
ú	4832	2.2%
ü	9	< 0.1%

Orden
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Territorial	163539
Nacional	69881
Corporación Autónoma	4385

Length

Max length	20
Median length	11
Mean length	10.28438
Min length	8

Characters and Unicode

Total characters	2445677
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Territorial
2nd row	Territorial
3rd row	Territorial
4th row	Territorial
5th row	Territorial

Common Values

Value	Count	Frequency (%)
Territorial	163539	68.8%
Nacional	69881	29.4%
Corporación Autónoma	4385	1.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
territorial	163539	67.5%
nacional	69881	28.9%
corporación	4385	1.8%
autónoma	4385	1.8%

Most occurring characters

Value	Count	Frequency (%)
r	499387	20.4%
i	401344	16.4%
a	312071	12.8%
o	246575	10.1%
l	233420	9.5%
t	167924	6.9%
T	163539	6.7%
e	163539	6.7%
n	78651	3.2%
c	74266	3.0%
Other values (8)	104961	4.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2199102	89.9%
Uppercase Letter	242190	9.9%
Space Separator	4385	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	499387	22.7%
i	401344	18.3%
a	312071	14.2%
o	246575	11.2%
l	233420	10.6%
t	167924	7.6%
e	163539	7.4%
n	78651	3.6%
c	74266	3.4%
ó	8770	0.4%
Other values (3)	13155	0.6%

Uppercase Letter

Value	Count	Frequency (%)
T	163539	67.5%
N	69881	28.9%
C	4385	1.8%
A	4385	1.8%

Space Separator

Value	Count	Frequency (%)
	4385	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2441292	99.8%
Common	4385	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	499387	20.5%
i	401344	16.4%
a	312071	12.8%
o	246575	10.1%
l	233420	9.6%
t	167924	6.9%
T	163539	6.7%
e	163539	6.7%
n	78651	3.2%
c	74266	3.0%
Other values (7)	100576	4.1%

Common

Value	Count	Frequency (%)
	4385	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2436907	99.6%
None	8770	0.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	499387	20.5%
i	401344	16.5%
a	312071	12.8%
o	246575	10.1%
l	233420	9.6%
t	167924	6.9%
T	163539	6.7%
e	163539	6.7%
n	78651	3.2%
c	74266	3.0%
Other values (7)	96191	3.9%

None

Value	Count	Frequency (%)
ó	8770	100.0%

Sector
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Servicio Público	63031
No aplica/No pertenece	39072
Salud y Protección Social	28874
Educación Nacional	13637
Trabajo	12138
Other values (20)	81053

Length

Max length	50
Median length	33
Mean length	18.251668
Min length	7

Characters and Unicode

Total characters	4340338
Distinct characters	43
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Salud y Protección Social
2nd row	Servicio Público
3rd row	Ambiente y Desarrollo Sostenible
4th row	No aplica/No pertenece
5th row	No aplica/No pertenece

Common Values

Value	Count	Frequency (%)
Servicio Público	63031	26.5%
No aplica/No pertenece	39072	16.4%
Salud y Protección Social	28874	12.1%
Educación Nacional	13637	5.7%
Trabajo	12138	5.1%
Ambiente y Desarrollo Sostenible	11531	4.8%
deportes	11057	4.6%
defensa	8477	3.6%
Cultura	7348	3.1%
Inclusión Social y Reconciliación	7103	3.0%
Other values (15)	35537	14.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
público	66190	11.4%
servicio	63031	10.8%
y	57930	10.0%
no	39072	6.7%
aplica/no	39072	6.7%
pertenece	39072	6.7%
social	35977	6.2%
salud	28874	5.0%
protección	28874	5.0%
nacional	13637	2.3%
Other values (40)	169962	29.2%

Most occurring characters

Value	Count	Frequency (%)
i	437435	10.1%
c	396521	9.1%
e	392953	9.1%
o	381176	8.8%
	343886	7.9%
a	304418	7.0%
l	252275	5.8%
r	233770	5.4%
n	195499	4.5%
t	140519	3.2%
Other values (33)	1261886	29.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3501472	80.7%
Uppercase Letter	451322	10.4%
Space Separator	343886	7.9%
Other Punctuation	43658	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	437435	12.5%
c	396521	11.3%
e	392953	11.2%
o	381176	10.9%
a	304418	8.7%
l	252275	7.2%
r	233770	6.7%
n	195499	5.6%
t	140519	4.0%
b	102109	2.9%
Other values (15)	664797	19.0%

Uppercase Letter

Value	Count	Frequency (%)
S	139413	30.9%
P	98699	21.9%
N	91781	20.3%
T	25304	5.6%
E	17730	3.9%
C	16899	3.7%
I	13484	3.0%
A	11531	2.6%
D	11531	2.6%
R	8001	1.8%
Other values (5)	16949	3.8%

Other Punctuation

Value	Count	Frequency (%)
/	39072	89.5%
,	4586	10.5%

Space Separator

Value	Count	Frequency (%)
	343886	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3952794	91.1%
Common	387544	8.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	437435	11.1%
c	396521	10.0%
e	392953	9.9%
o	381176	9.6%
a	304418	7.7%
l	252275	6.4%
r	233770	5.9%
n	195499	4.9%
t	140519	3.6%
S	139413	3.5%
Other values (30)	1078815	27.3%

Common

Value	Count	Frequency (%)
	343886	88.7%
/	39072	10.1%
,	4586	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4201265	96.8%
None	139073	3.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	437435	10.4%
c	396521	9.4%
e	392953	9.4%
o	381176	9.1%
	343886	8.2%
a	304418	7.2%
l	252275	6.0%
r	233770	5.6%
n	195499	4.7%
t	140519	3.3%
Other values (29)	1122813	26.7%

None

Value	Count	Frequency (%)
ú	66909	48.1%
ó	63290	45.5%
í	5710	4.1%
é	3164	2.3%

Rama
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Ejecutivo	194358
Corporación Autónoma	39959
Legislativo	1956
Judicial	1532

Length

Max length	20
Median length	9
Mean length	10.858367
Min length	8

Characters and Unicode

Total characters	2582174
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ejecutivo
2nd row	Ejecutivo
3rd row	Ejecutivo
4th row	Ejecutivo
5th row	Ejecutivo

Common Values

Value	Count	Frequency (%)
Ejecutivo	194358	81.7%
Corporación Autónoma	39959	16.8%
Legislativo	1956	0.8%
Judicial	1532	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ejecutivo	194358	70.0%
corporación	39959	14.4%
autónoma	39959	14.4%
legislativo	1956	0.7%
judicial	1532	0.6%

Most occurring characters

Value	Count	Frequency (%)
o	316191	12.2%
i	241293	9.3%
t	236273	9.2%
c	235849	9.1%
u	235849	9.1%
e	196314	7.6%
v	196314	7.6%
E	194358	7.5%
j	194358	7.5%
a	83406	3.2%
Other values (14)	451969	17.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2264451	87.7%
Uppercase Letter	277764	10.8%
Space Separator	39959	1.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	316191	14.0%
i	241293	10.7%
t	236273	10.4%
c	235849	10.4%
u	235849	10.4%
e	196314	8.7%
v	196314	8.7%
j	194358	8.6%
a	83406	3.7%
r	79918	3.5%
Other values (8)	248686	11.0%

Uppercase Letter

Value	Count	Frequency (%)
E	194358	70.0%
C	39959	14.4%
A	39959	14.4%
L	1956	0.7%
J	1532	0.6%

Space Separator

Value	Count	Frequency (%)
	39959	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2542215	98.5%
Common	39959	1.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	316191	12.4%
i	241293	9.5%
t	236273	9.3%
c	235849	9.3%
u	235849	9.3%
e	196314	7.7%
v	196314	7.7%
E	194358	7.6%
j	194358	7.6%
a	83406	3.3%
Other values (13)	412010	16.2%

Common

Value	Count	Frequency (%)
	39959	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2502256	96.9%
None	79918	3.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	316191	12.6%
i	241293	9.6%
t	236273	9.4%
c	235849	9.4%
u	235849	9.4%
e	196314	7.8%
v	196314	7.8%
E	194358	7.8%
j	194358	7.8%
a	83406	3.3%
Other values (13)	372051	14.9%

None

Value	Count	Frequency (%)
ó	79918	100.0%

Entidad Centralizada
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Descentralizada	128917
Centralizada	99751
No Definido	9137

Length

Max length	15
Median length	15
Mean length	13.587914
Min length	11

Characters and Unicode

Total characters	3231274
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Centralizada
2nd row	Descentralizada
3rd row	Centralizada
4th row	Descentralizada
5th row	Centralizada

Common Values

Value	Count	Frequency (%)
Descentralizada	128917	54.2%
Centralizada	99751	41.9%
No Definido	9137	3.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
descentralizada	128917	52.2%
centralizada	99751	40.4%
no	9137	3.7%
definido	9137	3.7%

Most occurring characters

Value	Count	Frequency (%)
a	686004	21.2%
e	366722	11.3%
i	246942	7.6%
d	237805	7.4%
n	237805	7.4%
l	228668	7.1%
z	228668	7.1%
t	228668	7.1%
r	228668	7.1%
D	138054	4.3%
Other values (7)	403270	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2975195	92.1%
Uppercase Letter	246942	7.6%
Space Separator	9137	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	686004	23.1%
e	366722	12.3%
i	246942	8.3%
d	237805	8.0%
n	237805	8.0%
l	228668	7.7%
z	228668	7.7%
t	228668	7.7%
r	228668	7.7%
c	128917	4.3%
Other values (3)	156328	5.3%

Uppercase Letter

Value	Count	Frequency (%)
D	138054	55.9%
C	99751	40.4%
N	9137	3.7%

Space Separator

Value	Count	Frequency (%)
	9137	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3222137	99.7%
Common	9137	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	686004	21.3%
e	366722	11.4%
i	246942	7.7%
d	237805	7.4%
n	237805	7.4%
l	228668	7.1%
z	228668	7.1%
t	228668	7.1%
r	228668	7.1%
D	138054	4.3%
Other values (6)	394133	12.2%

Common

Value	Count	Frequency (%)
	9137	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3231274	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	686004	21.2%
e	366722	11.3%
i	246942	7.6%
d	237805	7.4%
n	237805	7.4%
l	228668	7.1%
z	228668	7.1%
t	228668	7.1%
r	228668	7.1%
D	138054	4.3%
Other values (7)	403270	12.5%

Estado Contrato
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

En ejecución	141657
Modificado	53562
terminado	26724
Cerrado	13148
cedido	2211
Other values (3)	503

Length

Max length	12
Median length	12
Mean length	10.874851
Min length	6

Characters and Unicode

Total characters	2586094
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	En ejecución
2nd row	En ejecución
3rd row	Cerrado
4th row	En ejecución
5th row	En ejecución

Common Values

Value	Count	Frequency (%)
En ejecución	141657	59.6%
Modificado	53562	22.5%
terminado	26724	11.2%
Cerrado	13148	5.5%
cedido	2211	0.9%
Suspendido	438	0.2%
Activo	64	< 0.1%
Borrador	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
en	141657	37.3%
ejecución	141657	37.3%
modificado	53562	14.1%
terminado	26724	7.0%
cerrado	13148	3.5%
cedido	2211	0.6%
suspendido	438	0.1%
activo	64	< 0.1%
borrador	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
c	339151	13.1%
e	325835	12.6%
n	310476	12.0%
i	278218	10.8%
d	152295	5.9%
o	149711	5.8%
u	142095	5.5%
E	141657	5.5%
	141657	5.5%
j	141657	5.5%
Other values (14)	463342	17.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2235567	86.4%
Uppercase Letter	208870	8.1%
Space Separator	141657	5.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	339151	15.2%
e	325835	14.6%
n	310476	13.9%
i	278218	12.4%
d	152295	6.8%
o	149711	6.7%
u	142095	6.4%
j	141657	6.3%
ó	141657	6.3%
a	93435	4.2%
Other values (7)	161037	7.2%

Uppercase Letter

Value	Count	Frequency (%)
E	141657	67.8%
M	53562	25.6%
C	13148	6.3%
S	438	0.2%
A	64	< 0.1%
B	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	141657	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2444437	94.5%
Common	141657	5.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	339151	13.9%
e	325835	13.3%
n	310476	12.7%
i	278218	11.4%
d	152295	6.2%
o	149711	6.1%
u	142095	5.8%
E	141657	5.8%
j	141657	5.8%
ó	141657	5.8%
Other values (13)	321685	13.2%

Common

Value	Count	Frequency (%)
	141657	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2444437	94.5%
None	141657	5.5%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
c	339151	13.9%
e	325835	13.3%
n	310476	12.7%
i	278218	11.4%
d	152295	6.2%
o	149711	6.1%
u	142095	5.8%
E	141657	5.8%
	141657	5.8%
j	141657	5.8%
Other values (13)	321685	13.2%

None

Value	Count	Frequency (%)
ó	141657	100.0%

Tipo de Contrato
Categorical

HIGH CORRELATION IMBALANCE

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Prestación de servicios	209106
Otro	7095
DecreeLaw092/2017	7046
Suministros	4839
Compraventa	3189
Other values (17)	6530

Length

Max length	26
Median length	23
Mean length	21.62066
Min length	4

Characters and Unicode

Total characters	5141501
Distinct characters	41
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Prestación de servicios
2nd row	Prestación de servicios
3rd row	Prestación de servicios
4th row	Prestación de servicios
5th row	Prestación de servicios

Common Values

Value	Count	Frequency (%)
Prestación de servicios	209106	87.9%
Otro	7095	3.0%
DecreeLaw092/2017	7046	3.0%
Suministros	4839	2.0%
Compraventa	3189	1.3%
Arrendamiento de inmuebles	2078	0.9%
Obra	1652	0.7%
No Especificado	892	0.4%
Interventoría	466	0.2%
Comodato	435	0.2%
Other values (12)	1007	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	211314	31.9%
servicios	209158	31.6%
prestación	209106	31.6%
otro	7095	1.1%
decreelaw092/2017	7046	1.1%
suministros	4839	0.7%
compraventa	3189	0.5%
arrendamiento	2169	0.3%
inmuebles	2080	0.3%
obra	1652	0.2%
Other values (20)	3811	0.6%

Most occurring characters

Value	Count	Frequency (%)
e	664988	12.9%
i	643404	12.5%
s	641014	12.5%
r	448317	8.7%
c	427311	8.3%
	423654	8.2%
o	231402	4.5%
a	228677	4.4%
t	228241	4.4%
n	225024	4.4%
Other values (31)	979469	19.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4415644	85.9%
Space Separator	423654	8.2%
Uppercase Letter	245835	4.8%
Decimal Number	49322	1.0%
Other Punctuation	7046	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	664988	15.1%
i	643404	14.6%
s	641014	14.5%
r	448317	10.2%
c	427311	9.7%
o	231402	5.2%
a	228677	5.2%
t	228241	5.2%
n	225024	5.1%
d	214867	4.9%
Other values (12)	462399	10.5%

Uppercase Letter

Value	Count	Frequency (%)
P	209159	85.1%
O	8747	3.6%
L	7046	2.9%
D	7046	2.9%
S	5241	2.1%
C	4030	1.6%
A	2215	0.9%
E	925	0.4%
N	903	0.4%
I	466	0.2%
Other values (2)	57	< 0.1%

Decimal Number

Value	Count	Frequency (%)
0	14092	28.6%
2	14092	28.6%
9	7046	14.3%
1	7046	14.3%
7	7046	14.3%

Space Separator

Value	Count	Frequency (%)
	423654	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	7046	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4661479	90.7%
Common	480022	9.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	664988	14.3%
i	643404	13.8%
s	641014	13.8%
r	448317	9.6%
c	427311	9.2%
o	231402	5.0%
a	228677	4.9%
t	228241	4.9%
n	225024	4.8%
d	214867	4.6%
Other values (24)	708234	15.2%

Common

Value	Count	Frequency (%)
	423654	88.3%
0	14092	2.9%
2	14092	2.9%
9	7046	1.5%
/	7046	1.5%
1	7046	1.5%
7	7046	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4931509	95.9%
None	209992	4.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	664988	13.5%
i	643404	13.0%
s	641014	13.0%
r	448317	9.1%
c	427311	8.7%
	423654	8.6%
o	231402	4.7%
a	228677	4.6%
t	228241	4.6%
n	225024	4.6%
Other values (28)	769477	15.6%

None

Value	Count	Frequency (%)
ó	209127	99.6%
í	858	0.4%
ú	7	< 0.1%

Modalidad de Contratacion
Categorical

HIGH CORRELATION IMBALANCE

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Contratación directa	190899
Contratación régimen especial	26602
Mínima cuantía	10422
Contratación Directa (con ofertas)	2157
Selección Abreviada de Menor Cuantía	2012
Other values (11)	5713

Length

Max length	59
Median length	20
Mean length	21.351725
Min length	11

Characters and Unicode

Total characters	5077547
Distinct characters	42
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Contratación directa
2nd row	Contratación directa
3rd row	Contratación directa
4th row	Contratación directa
5th row	Contratación directa

Common Values

Value	Count	Frequency (%)
Contratación directa	190899	80.3%
Contratación régimen especial	26602	11.2%
Mínima cuantía	10422	4.4%
Contratación Directa (con ofertas)	2157	0.9%
Selección Abreviada de Menor Cuantía	2012	0.8%
Contratación régimen especial (con ofertas)	1829	0.8%
Selección abreviada subasta inversa	1544	0.6%
No Definido	670	0.3%
CCE-20-Concurso_Meritos_Sin_Lista_Corta_1Sobre	601	0.3%
Licitación pública	545	0.2%
Other values (6)	524	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
contratación	221487	42.4%
directa	193056	37.0%
régimen	28431	5.4%
especial	28431	5.4%
cuantía	12434	2.4%
mínima	10422	2.0%
con	4004	0.8%
ofertas	3986	0.8%
abreviada	3633	0.7%
selección	3556	0.7%
Other values (26)	12482	2.4%

Most occurring characters

Value	Count	Frequency (%)
a	721478	14.2%
t	657022	12.9%
n	508834	10.0%
i	498410	9.8%
c	468763	9.2%
r	457273	9.0%
e	301219	5.9%
	284117	5.6%
o	236256	4.7%
ó	226022	4.5%
Other values (32)	718153	14.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4526600	89.1%
Space Separator	284117	5.6%
Uppercase Letter	252848	5.0%
Open Punctuation	3986	0.1%
Close Punctuation	3986	0.1%
Connector Punctuation	3005	0.1%
Decimal Number	1803	< 0.1%
Dash Punctuation	1202	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	721478	15.9%
t	657022	14.5%
n	508834	11.2%
i	498410	11.0%
c	468763	10.4%
r	457273	10.1%
e	301219	6.7%
o	236256	5.2%
ó	226022	5.0%
d	197334	4.4%
Other values (13)	253989	5.6%

Uppercase Letter

Value	Count	Frequency (%)
C	225993	89.4%
M	13228	5.2%
S	4912	1.9%
D	2827	1.1%
A	2128	0.8%
L	1562	0.6%
N	670	0.3%
E	619	0.2%
P	455	0.2%
O	377	0.1%

Decimal Number

Value	Count	Frequency (%)
2	601	33.3%
0	601	33.3%
1	601	33.3%

Space Separator

Value	Count	Frequency (%)
	284117	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3986	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3986	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	3005	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1202	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4779448	94.1%
Common	298099	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	721478	15.1%
t	657022	13.7%
n	508834	10.6%
i	498410	10.4%
c	468763	9.8%
r	457273	9.6%
e	301219	6.3%
o	236256	4.9%
ó	226022	4.7%
C	225993	4.7%
Other values (24)	478178	10.0%

Common

Value	Count	Frequency (%)
	284117	95.3%
(	3986	1.3%
)	3986	1.3%
_	3005	1.0%
-	1202	0.4%
2	601	0.2%
0	601	0.2%
1	601	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4799264	94.5%
None	278283	5.5%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	721478	15.0%
t	657022	13.7%
n	508834	10.6%
i	498410	10.4%
c	468763	9.8%
r	457273	9.5%
e	301219	6.3%
	284117	5.9%
o	236256	4.9%
C	225993	4.7%
Other values (28)	439899	9.2%

None

Value	Count	Frequency (%)
ó	226022	81.2%
é	28444	10.2%
í	22856	8.2%
ú	961	0.3%

Fecha de Firma
Date

Distinct	683
Distinct (%)	0.3%
Missing	1
Missing (%)	< 0.1%
Memory size	3.6 MiB

Minimum	2020-06-04 00:00:00
Maximum	2023-07-10 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Fecha de Inicio del Contrato
Date

Distinct	599
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Minimum	2022-01-01 00:00:00
Maximum	2025-12-05 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Fecha de Fin del Contrato
Date

Distinct	1392
Distinct (%)	0.6%
Missing	1
Missing (%)	< 0.1%
Memory size	3.6 MiB

Minimum	2021-06-30 00:00:00
Maximum	2051-01-27 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Fecha de Inicio de Ejecucion
Date

Distinct	7
Distinct (%)	100.0%
Missing	237798
Missing (%)	> 99.9%
Memory size	3.6 MiB

Minimum	2022-02-28 00:00:00
Maximum	2023-05-31 00:00:00

Histogram

Histogram with fixed size bins (bins=7)

Fecha de Fin de Ejecucion
Date

Distinct	3
Distinct (%)	42.9%
Missing	237798
Missing (%)	> 99.9%
Memory size	3.6 MiB

Minimum	2023-04-24 00:00:00
Maximum	2023-08-31 00:00:00

Histogram

Histogram with fixed size bins (bins=3)

Condiciones de Entrega
Categorical

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

A convenir	98672
Como acordado previamente	67262
No Definido	64684
Transporte incluido	6012
Transporte no incluído	868
Other values (8)	307

Length

Max length	58
Median length	56
Mean length	14.829041
Min length	10

Characters and Unicode

Total characters	3526420
Distinct characters	38
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	A convenir
2nd row	A convenir
3rd row	A convenir
4th row	A convenir
5th row	Como acordado previamente

Common Values

Value	Count	Frequency (%)
A convenir	98672	41.5%
Como acordado previamente	67262	28.3%
No Definido	64684	27.2%
Transporte incluido	6012	2.5%
Transporte no incluído	868	0.4%
DAP - Entregado en un punto (lugar de destino convenido)	138	0.1%
Transporte a cargo del comprador	133	0.1%
CPT - Transporte pagado hasta (lugar de destino convenido)	13	< 0.1%
CFR - Cost and freight	12	< 0.1%
DDP - Delivery duty place	4	< 0.1%
Other values (3)	7	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	98805	18.1%
convenir	98672	18.1%
como	67262	12.3%
acordado	67262	12.3%
previamente	67262	12.3%
no	65552	12.0%
definido	64684	11.9%
transporte	7026	1.3%
incluido	6012	1.1%
incluído	868	0.2%
Other values (34)	2002	0.4%

Most occurring characters

Value	Count	Frequency (%)
o	513019	14.5%
e	373069	10.6%
n	345093	9.8%
i	308527	8.7%
	307602	8.7%
r	247968	7.0%
a	209589	5.9%
d	206980	5.9%
c	173238	4.9%
v	166092	4.7%
Other values (28)	675243	19.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2915329	82.7%
Space Separator	307602	8.7%
Uppercase Letter	303012	8.6%
Dash Punctuation	175	< 0.1%
Open Punctuation	151	< 0.1%
Close Punctuation	151	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	513019	17.6%
e	373069	12.8%
n	345093	11.8%
i	308527	10.6%
r	247968	8.5%
a	209589	7.2%
d	206980	7.1%
c	173238	5.9%
v	166092	5.7%
m	134660	4.6%
Other values (12)	237094	8.1%

Uppercase Letter

Value	Count	Frequency (%)
A	98813	32.6%
C	67305	22.2%
D	64840	21.4%
N	64684	21.3%
T	7042	2.3%
P	158	0.1%
E	140	< 0.1%
F	12	< 0.1%
R	12	< 0.1%
I	3	< 0.1%
Other values (2)	3	< 0.1%

Space Separator

Value	Count	Frequency (%)
	307602	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	175	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	151	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	151	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3218341	91.3%
Common	308079	8.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	513019	15.9%
e	373069	11.6%
n	345093	10.7%
i	308527	9.6%
r	247968	7.7%
a	209589	6.5%
d	206980	6.4%
c	173238	5.4%
v	166092	5.2%
m	134660	4.2%
Other values (24)	540106	16.8%

Common

Value	Count	Frequency (%)
	307602	99.8%
-	175	0.1%
(	151	< 0.1%
)	151	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3525552	> 99.9%
None	868	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	513019	14.6%
e	373069	10.6%
n	345093	9.8%
i	308527	8.8%
	307602	8.7%
r	247968	7.0%
a	209589	5.9%
d	206980	5.9%
c	173238	4.9%
v	166092	4.7%
Other values (27)	674375	19.1%

None

Value	Count	Frequency (%)
í	868	100.0%

TipoDocProveedor
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Cédula de Ciudadanía	204388
No Definido	32099
Sin Descripcion	791
Cédula de Extranjería	430
Tarjeta de Identidad	45
Other values (3)	52

Length

Max length	31
Median length	20
Mean length	18.769891
Min length	9

Characters and Unicode

Total characters	4463574
Distinct characters	29
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cédula de Ciudadanía
2nd row	Cédula de Ciudadanía
3rd row	Cédula de Ciudadanía
4th row	Cédula de Ciudadanía
5th row	Cédula de Ciudadanía

Common Values

Value	Count	Frequency (%)
Cédula de Ciudadanía	204388	85.9%
No Definido	32099	13.5%
Sin Descripcion	791	0.3%
Cédula de Extranjería	430	0.2%
Tarjeta de Identidad	45	< 0.1%
Pasaporte	31	< 0.1%
Permiso por Protección Temporal	11	< 0.1%
Permiso especial de permanencia	10	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
de	204873	30.1%
cédula	204818	30.1%
ciudadanía	204388	30.0%
no	32099	4.7%
definido	32099	4.7%
sin	791	0.1%
descripcion	791	0.1%
extranjería	430	0.1%
identidad	45	< 0.1%
tarjeta	45	< 0.1%
Other values (7)	105	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
d	850701	19.1%
a	819080	18.4%
	442679	9.9%
C	409206	9.2%
u	409206	9.2%
i	271056	6.1%
n	238575	5.3%
e	238397	5.3%
l	204839	4.6%
í	204818	4.6%
Other values (19)	375017	8.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3545315	79.4%
Uppercase Letter	475580	10.7%
Space Separator	442679	9.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	850701	24.0%
a	819080	23.1%
u	409206	11.5%
i	271056	7.6%
n	238575	6.7%
e	238397	6.7%
l	204839	5.8%
í	204818	5.8%
é	204818	5.8%
o	65074	1.8%
Other values (10)	38751	1.1%

Uppercase Letter

Value	Count	Frequency (%)
C	409206	86.0%
D	32890	6.9%
N	32099	6.7%
S	791	0.2%
E	430	0.1%
P	63	< 0.1%
T	56	< 0.1%
I	45	< 0.1%

Space Separator

Value	Count	Frequency (%)
	442679	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4020895	90.1%
Common	442679	9.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	850701	21.2%
a	819080	20.4%
C	409206	10.2%
u	409206	10.2%
i	271056	6.7%
n	238575	5.9%
e	238397	5.9%
l	204839	5.1%
í	204818	5.1%
é	204818	5.1%
Other values (18)	170199	4.2%

Common

Value	Count	Frequency (%)
	442679	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4053927	90.8%
None	409647	9.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	850701	21.0%
a	819080	20.2%
	442679	10.9%
C	409206	10.1%
u	409206	10.1%
i	271056	6.7%
n	238575	5.9%
e	238397	5.9%
l	204839	5.1%
o	65074	1.6%
Other values (16)	105114	2.6%

None

Value	Count	Frequency (%)
í	204818	50.0%
é	204818	50.0%
ó	11	< 0.1%

Es Grupo
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No	236458
Si	1347

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	475610
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	236458	99.4%
Si	1347	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	236458	99.4%
si	1347	0.6%

Most occurring characters

Value	Count	Frequency (%)
N	236458	49.7%
o	236458	49.7%
S	1347	0.3%
i	1347	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	237805	50.0%
Lowercase Letter	237805	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	236458	99.4%
S	1347	0.6%

Lowercase Letter

Value	Count	Frequency (%)
o	236458	99.4%
i	1347	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	475610	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	236458	49.7%
o	236458	49.7%
S	1347	0.3%
i	1347	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475610	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	236458	49.7%
o	236458	49.7%
S	1347	0.3%
i	1347	0.3%

Es Pyme
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No	205615
Si	32190

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	475610
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	205615	86.5%
Si	32190	13.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	205615	86.5%
si	32190	13.5%

Most occurring characters

Value	Count	Frequency (%)
N	205615	43.2%
o	205615	43.2%
S	32190	6.8%
i	32190	6.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	237805	50.0%
Lowercase Letter	237805	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	205615	86.5%
S	32190	13.5%

Lowercase Letter

Value	Count	Frequency (%)
o	205615	86.5%
i	32190	13.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	475610	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	205615	43.2%
o	205615	43.2%
S	32190	6.8%
i	32190	6.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475610	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	205615	43.2%
o	205615	43.2%
S	32190	6.8%
i	32190	6.8%

Habilita Pago Adelantado
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No	236815
No Definido	850
Si	140

Length

Max length	11
Median length	2
Mean length	2.0321692
Min length	2

Characters and Unicode

Total characters	483260
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	236815	99.6%
No Definido	850	0.4%
Si	140	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	237665	99.6%
definido	850	0.4%
si	140	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	238515	49.4%
N	237665	49.2%
i	1840	0.4%
	850	0.2%
D	850	0.2%
e	850	0.2%
f	850	0.2%
n	850	0.2%
d	850	0.2%
S	140	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	243755	50.4%
Uppercase Letter	238655	49.4%
Space Separator	850	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	238515	97.9%
i	1840	0.8%
e	850	0.3%
f	850	0.3%
n	850	0.3%
d	850	0.3%

Uppercase Letter

Value	Count	Frequency (%)
N	237665	99.6%
D	850	0.4%
S	140	0.1%

Space Separator

Value	Count	Frequency (%)
	850	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	482410	99.8%
Common	850	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	238515	49.4%
N	237665	49.3%
i	1840	0.4%
D	850	0.2%
e	850	0.2%
f	850	0.2%
n	850	0.2%
d	850	0.2%
S	140	< 0.1%

Common

Value	Count	Frequency (%)
	850	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	483260	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	238515	49.4%
N	237665	49.2%
i	1840	0.4%
	850	0.2%
D	850	0.2%
e	850	0.2%
f	850	0.2%
n	850	0.2%
d	850	0.2%
S	140	< 0.1%

Liquidación
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No	213291
Si	24514

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	475610
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	213291	89.7%
Si	24514	10.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	213291	89.7%
si	24514	10.3%

Most occurring characters

Value	Count	Frequency (%)
N	213291	44.8%
o	213291	44.8%
S	24514	5.2%
i	24514	5.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	237805	50.0%
Lowercase Letter	237805	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	213291	89.7%
S	24514	10.3%

Lowercase Letter

Value	Count	Frequency (%)
o	213291	89.7%
i	24514	10.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	475610	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	213291	44.8%
o	213291	44.8%
S	24514	5.2%
i	24514	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475610	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	213291	44.8%
o	213291	44.8%
S	24514	5.2%
i	24514	5.2%

Obligación Ambiental
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No	232171
Si	5634

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	475610
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	232171	97.6%
Si	5634	2.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	232171	97.6%
si	5634	2.4%

Most occurring characters

Value	Count	Frequency (%)
N	232171	48.8%
o	232171	48.8%
S	5634	1.2%
i	5634	1.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	237805	50.0%
Lowercase Letter	237805	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	232171	97.6%
S	5634	2.4%

Lowercase Letter

Value	Count	Frequency (%)
o	232171	97.6%
i	5634	2.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	475610	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	232171	48.8%
o	232171	48.8%
S	5634	1.2%
i	5634	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475610	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	232171	48.8%
o	232171	48.8%
S	5634	1.2%
i	5634	1.2%

Obligaciones Postconsumo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No	237712
Si	93

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	475610
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	237712	> 99.9%
Si	93	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	237712	> 99.9%
si	93	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	237712	50.0%
o	237712	50.0%
S	93	< 0.1%
i	93	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	237805	50.0%
Lowercase Letter	237805	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	237712	> 99.9%
S	93	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
o	237712	> 99.9%
i	93	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	475610	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	237712	50.0%
o	237712	50.0%
S	93	< 0.1%
i	93	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475610	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	237712	50.0%
o	237712	50.0%
S	93	< 0.1%
i	93	< 0.1%

Reversion
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No	237790
Si	15

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	475610
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	237790	> 99.9%
Si	15	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	237790	> 99.9%
si	15	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	237790	50.0%
o	237790	50.0%
S	15	< 0.1%
i	15	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	237805	50.0%
Lowercase Letter	237805	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	237790	> 99.9%
S	15	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
o	237790	> 99.9%
i	15	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	475610	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	237790	50.0%
o	237790	50.0%
S	15	< 0.1%
i	15	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475610	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	237790	50.0%
o	237790	50.0%
S	15	< 0.1%
i	15	< 0.1%

Valor del Contrato
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	80967
Distinct (%)	34.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.2800331 × 10⁸

Minimum	0
Maximum	1.4207686 × 10¹⁴
Zeros	1279
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	3697813.4
Q1	10333333
median	19452066
Q3	37986667
95-th percentile	1.4610228 × 10⁸
Maximum	1.4207686 × 10¹⁴
Range	1.4207686 × 10¹⁴
Interquartile range (IQR)	27653334

Descriptive statistics

Standard deviation	2.9136572 × 10¹¹
Coefficient of variation (CV)	400.22582
Kurtosis	237748.1
Mean	7.2800331 × 10⁸
Median Absolute Deviation (MAD)	11052066
Skewness	487.56522
Sum	1.7312283 × 10¹⁴
Variance	8.4893984 × 10²²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12000000	2410	1.0%
18000000	1876	0.8%
9000000	1839	0.8%
10000000	1622	0.7%
15000000	1582	0.7%
6000000	1560	0.7%
24000000	1406	0.6%
8000000	1377	0.6%
14000000	1362	0.6%
21000000	1303	0.5%
Other values (80957)	221468	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1279	0.5%
1	23	< 0.1%
3000	1	< 0.1%
3703	1	< 0.1%
10000	1	< 0.1%
11090	1	< 0.1%
16824	1	< 0.1%
18000	1	< 0.1%
18674	1	< 0.1%
22262	1	< 0.1%

Value	Count	Frequency (%)
1.420768642 × 10¹⁴	1	< 0.1%
8.61222696 × 10¹¹	1	< 0.1%
6.300077483 × 10¹¹	1	< 0.1%
4.547759218 × 10¹¹	1	< 0.1%
3.448830208 × 10¹¹	1	< 0.1%
3.19366761 × 10¹¹	1	< 0.1%
3.190473682 × 10¹¹	1	< 0.1%
2.449598007 × 10¹¹	1	< 0.1%
2.231804056 × 10¹¹	1	< 0.1%
2.202424716 × 10¹¹	1	< 0.1%

Valor de pago adelantado
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	165
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	284200.87

Minimum	0
Maximum	1.3805894 × 10¹⁰
Zeros	237635
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1.3805894 × 10¹⁰
Range	1.3805894 × 10¹⁰
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	38403317
Coefficient of variation (CV)	135.12737
Kurtosis	84842.957
Mean	284200.87
Median Absolute Deviation (MAD)	0
Skewness	268.35151
Sum	6.7584388 × 10¹⁰
Variance	1.4748148 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	237635	99.9%
15000000	3	< 0.1%
37500000	2	< 0.1%
100000000	2	< 0.1%
22250000	2	< 0.1%
50000000	2	< 0.1%
537766	1	< 0.1%
40000000	1	< 0.1%
5534101	1	< 0.1%
66496099	1	< 0.1%
Other values (155)	155	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	237635	99.9%
537766	1	< 0.1%
2064000	1	< 0.1%
2250000	1	< 0.1%
3681834	1	< 0.1%
4900000	1	< 0.1%
5150000	1	< 0.1%
5534101	1	< 0.1%
5980355	1	< 0.1%
7578913	1	< 0.1%

Value	Count	Frequency (%)
1.380589369 × 10¹⁰	1	< 0.1%
9034652501	1	< 0.1%
4492512530	1	< 0.1%
3941224493	1	< 0.1%
3386758564	1	< 0.1%
2749424729	1	< 0.1%
2075559772	1	< 0.1%
2026289484	1	< 0.1%
1954274210	1	< 0.1%
1269223998	1	< 0.1%

Valor Facturado
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	52155
Distinct (%)	21.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25467689

Minimum	0
Maximum	2.0702827 × 10¹¹
Zeros	114088
Zeros (%)	48.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2100000
Q3	14605390
95-th percentile	50400000
Maximum	2.0702827 × 10¹¹
Range	2.0702827 × 10¹¹
Interquartile range (IQR)	14605390

Descriptive statistics

Standard deviation	5.3329735 × 10⁸
Coefficient of variation (CV)	20.940155
Kurtosis	96663.912
Mean	25467689
Median Absolute Deviation (MAD)	2100000
Skewness	262.28192
Sum	6.0563437 × 10¹²
Variance	2.8440606 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	114088	48.0%
12000000	1231	0.5%
6000000	1154	0.5%
9000000	1070	0.4%
18000000	802	0.3%
10000000	781	0.3%
15000000	779	0.3%
8000000	758	0.3%
4000000	636	0.3%
7500000	613	0.3%
Other values (52145)	115893	48.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	114088	48.0%
1	1	< 0.1%
3	1	< 0.1%
6	1	< 0.1%
11	1	< 0.1%
46	1	< 0.1%
264	1	< 0.1%
675	1	< 0.1%
7050	1	< 0.1%
22000	1	< 0.1%

Value	Count	Frequency (%)
2.070282742 × 10¹¹	1	< 0.1%
6.018851596 × 10¹⁰	1	< 0.1%
4.679517814 × 10¹⁰	1	< 0.1%
3.050190129 × 10¹⁰	1	< 0.1%
2.877481247 × 10¹⁰	1	< 0.1%
2.569428908 × 10¹⁰	1	< 0.1%
2.525695662 × 10¹⁰	1	< 0.1%
2.447199937 × 10¹⁰	1	< 0.1%
2.356861877 × 10¹⁰	1	< 0.1%
2.255936405 × 10¹⁰	1	< 0.1%

Valor Pendiente de Pago
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	76052
Distinct (%)	32.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1196645 × 10⁸

Minimum	-32912750
Maximum	8.612227 × 10¹¹
Zeros	44489
Zeros (%)	18.7%
Negative	72
Negative (%)	< 0.1%
Memory size	3.6 MiB

Quantile statistics

Minimum	-32912750
5-th percentile	0
Q1	2619000
median	12150000
Q3	27084266
95-th percentile	1.11414 × 10⁸
Maximum	8.612227 × 10¹¹
Range	8.6125561 × 10¹¹
Interquartile range (IQR)	24465266

Descriptive statistics

Standard deviation	3.1361043 × 10⁹
Coefficient of variation (CV)	28.009322
Kurtosis	34888.181
Mean	1.1196645 × 10⁸
Median Absolute Deviation (MAD)	11483334
Skewness	160.96999
Sum	2.6626182 × 10¹³
Variance	9.8351504 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	44489	18.7%
12000000	1747	0.7%
9000000	1396	0.6%
10000000	1243	0.5%
18000000	1197	0.5%
6000000	1170	0.5%
8000000	1129	0.5%
15000000	1064	0.4%
14000000	1031	0.4%
20000000	950	0.4%
Other values (76042)	182389	76.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-32912750	1	< 0.1%
-28673333	1	< 0.1%
-24917750	1	< 0.1%
-19683358	1	< 0.1%
-18840334	1	< 0.1%
-16534018	1	< 0.1%
-16308224	1	< 0.1%
-14560000	1	< 0.1%
-13774532	1	< 0.1%
-12480667	1	< 0.1%

Value	Count	Frequency (%)
8.61222696 × 10¹¹	1	< 0.1%
6.300077483 × 10¹¹	1	< 0.1%
4.547759218 × 10¹¹	1	< 0.1%
3.448830208 × 10¹¹	1	< 0.1%
3.19366761 × 10¹¹	1	< 0.1%
3.190473682 × 10¹¹	1	< 0.1%
2.449598007 × 10¹¹	1	< 0.1%
2.231804056 × 10¹¹	1	< 0.1%
2.202424716 × 10¹¹	1	< 0.1%
2.11033526 × 10¹¹	1	< 0.1%

Valor Pagado
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	41558
Distinct (%)	17.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18457961

Minimum	0
Maximum	1.86303 × 10¹¹
Zeros	144403
Zeros (%)	60.7%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9846999
95-th percentile	41973750
Maximum	1.86303 × 10¹¹
Range	1.86303 × 10¹¹
Interquartile range (IQR)	9846999

Descriptive statistics

Standard deviation	4.6956491 × 10⁸
Coefficient of variation (CV)	25.439696
Kurtosis	105935.94
Mean	18457961
Median Absolute Deviation (MAD)	0
Skewness	281.63166
Sum	4.3893954 × 10¹²
Variance	2.2049121 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	144403	60.7%
6000000	790	0.3%
12000000	768	0.3%
9000000	742	0.3%
15000000	589	0.2%
10000000	538	0.2%
8000000	522	0.2%
4000000	504	0.2%
18000000	502	0.2%
7500000	426	0.2%
Other values (41548)	88021	37.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	144403	60.7%
1	1	< 0.1%
3	2	< 0.1%
46	1	< 0.1%
264	1	< 0.1%
7050	1	< 0.1%
22000	1	< 0.1%
27499	1	< 0.1%
35800	1	< 0.1%
36325	1	< 0.1%

Value	Count	Frequency (%)
1.86303005 × 10¹¹	1	< 0.1%
6.018851596 × 10¹⁰	1	< 0.1%
4.679517814 × 10¹⁰	1	< 0.1%
2.569428908 × 10¹⁰	1	< 0.1%
2.525695662 × 10¹⁰	1	< 0.1%
2.502795119 × 10¹⁰	1	< 0.1%
2.356861877 × 10¹⁰	1	< 0.1%
2.142874612 × 10¹⁰	1	< 0.1%
1.658942382 × 10¹⁰	1	< 0.1%
1.571908889 × 10¹⁰	1	< 0.1%

Valor Amortizado
Real number (ℝ)

SKEWED ZEROS

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14546.895

Minimum	0
Maximum	7.1725785 × 10⁸
Zeros	237779
Zeros (%)	> 99.9%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	7.1725785 × 10⁸
Range	7.1725785 × 10⁸
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2369747.2
Coefficient of variation (CV)	162.90399
Kurtosis	55463.353
Mean	14546.895
Median Absolute Deviation (MAD)	0
Skewness	221.50553
Sum	3.4593244 × 10⁹
Variance	5.615702 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	237779	> 99.9%
47662948	1	< 0.1%
37500000	1	< 0.1%
13075620	1	< 0.1%
9946822	1	< 0.1%
38473586	1	< 0.1%
48400000	1	< 0.1%
10000000	1	< 0.1%
18073700	1	< 0.1%
69992544	1	< 0.1%
Other values (17)	17	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	237779	> 99.9%
2392142	1	< 0.1%
7140000	1	< 0.1%
7993000	1	< 0.1%
9946822	1	< 0.1%
10000000	1	< 0.1%
13075620	1	< 0.1%
18073700	1	< 0.1%
22250000	1	< 0.1%
24200000	1	< 0.1%

Value	Count	Frequency (%)
717257850	1	< 0.1%
548710541	1	< 0.1%
450789542	1	< 0.1%
292713500	1	< 0.1%
286814675	1	< 0.1%
227650000	1	< 0.1%
197522363	1	< 0.1%
175997600	1	< 0.1%
83500000	1	< 0.1%
69992544	1	< 0.1%

Valor Pendiente de Amortizacion
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	150
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	269653.97

Minimum	-9946822
Maximum	1.3805894 × 10¹⁰
Zeros	237652
Zeros (%)	99.9%
Negative	1
Negative (%)	< 0.1%
Memory size	3.6 MiB

Quantile statistics

Minimum	-9946822
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1.3805894 × 10¹⁰
Range	1.3815841 × 10¹⁰
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	38329455
Coefficient of variation (CV)	142.14311
Kurtosis	85498.454
Mean	269653.97
Median Absolute Deviation (MAD)	0
Skewness	269.85459
Sum	6.4125063 × 10¹⁰
Variance	1.4691471 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	237652	99.9%
15000000	3	< 0.1%
100000000	2	< 0.1%
40000000	2	< 0.1%
38473586	1	< 0.1%
15960399	1	< 0.1%
58400000	1	< 0.1%
205039875	1	< 0.1%
4900000	1	< 0.1%
2064000	1	< 0.1%
Other values (140)	140	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-9946822	1	< 0.1%
0	237652	99.9%
537766	1	< 0.1%
1260000	1	< 0.1%
2064000	1	< 0.1%
2250000	1	< 0.1%
2537186	1	< 0.1%
3588213	1	< 0.1%
3681834	1	< 0.1%
4900000	1	< 0.1%

Value	Count	Frequency (%)
1.380589369 × 10¹⁰	1	< 0.1%
9034652501	1	< 0.1%
4492512530	1	< 0.1%
3941224493	1	< 0.1%
3386758564	1	< 0.1%
2749424729	1	< 0.1%
2075559772	1	< 0.1%
2026289484	1	< 0.1%
1954274210	1	< 0.1%
1269223998	1	< 0.1%

Valor Pendiente de Ejecucion
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	76121
Distinct (%)	32.1%
Missing	856
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	1.1228875 × 10⁸

Minimum	-2.1847204 × 10⁸
Maximum	8.612227 × 10¹¹
Zeros	43569
Zeros (%)	18.3%
Negative	130
Negative (%)	0.1%
Memory size	3.6 MiB

Quantile statistics

Minimum	-2.1847204 × 10⁸
5-th percentile	0
Q1	2760000
median	12240000
Q3	27200000
95-th percentile	1.1186503 × 10⁸
Maximum	8.612227 × 10¹¹
Range	8.6144117 × 10¹¹
Interquartile range (IQR)	24440000

Descriptive statistics

Standard deviation	3.1410417 × 10⁹
Coefficient of variation (CV)	27.972898
Kurtosis	34794.39
Mean	1.1228875 × 10⁸
Median Absolute Deviation (MAD)	11422303
Skewness	160.78279
Sum	2.6606707 × 10¹³
Variance	9.8661431 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	43569	18.3%
12000000	1746	0.7%
9000000	1395	0.6%
10000000	1243	0.5%
18000000	1200	0.5%
6000000	1169	0.5%
8000000	1129	0.5%
15000000	1065	0.4%
14000000	1034	0.4%
20000000	948	0.4%
Other values (76111)	182451	76.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-218472035	1	< 0.1%
-32912750	1	< 0.1%
-28673333	1	< 0.1%
-24917750	1	< 0.1%
-23720700	1	< 0.1%
-19683358	1	< 0.1%
-18840334	1	< 0.1%
-16534018	1	< 0.1%
-16308224	1	< 0.1%
-14560000	1	< 0.1%

Value	Count	Frequency (%)
8.61222696 × 10¹¹	1	< 0.1%
6.300077483 × 10¹¹	1	< 0.1%
4.547759218 × 10¹¹	1	< 0.1%
3.448830208 × 10¹¹	1	< 0.1%
3.19366761 × 10¹¹	1	< 0.1%
3.190473682 × 10¹¹	1	< 0.1%
2.449598007 × 10¹¹	1	< 0.1%
2.231804056 × 10¹¹	1	< 0.1%
2.202424716 × 10¹¹	1	< 0.1%
2.11033526 × 10¹¹	1	< 0.1%

Saldo CDP
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	72450
Distinct (%)	30.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7665435 × 10¹⁰

Minimum	0
Maximum	6.0120229 × 10¹⁵
Zeros	15160
Zeros (%)	6.4%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11756260
median	30149309
Q3	2.0745022 × 10⁸
95-th percentile	5.057437 × 10⁹
Maximum	6.0120229 × 10¹⁵
Range	6.0120229 × 10¹⁵
Interquartile range (IQR)	1.9569396 × 10⁸

Descriptive statistics

Standard deviation	1.2330093 × 10¹³
Coefficient of variation (CV)	445.68587
Kurtosis	237681.51
Mean	2.7665435 × 10¹⁰
Median Absolute Deviation (MAD)	24660691
Skewness	487.46349
Sum	6.5789787 × 10¹⁵
Variance	1.520312 × 10²⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	15160	6.4%
12000000	1596	0.7%
15000000	1333	0.6%
10000000	1269	0.5%
9000000	1198	0.5%
18000000	1180	0.5%
6000000	1066	0.4%
20000000	1055	0.4%
8000000	1017	0.4%
24000000	984	0.4%
Other values (72440)	211947	89.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	15160	6.4%
1	14	< 0.1%
3	1	< 0.1%
30	1	< 0.1%
155	1	< 0.1%
342	1	< 0.1%
10000	1	< 0.1%
28000	1	< 0.1%
58151	1	< 0.1%
60000	1	< 0.1%

Value	Count	Frequency (%)
6.012022895 × 10¹⁵	1	< 0.1%
4.301160446 × 10¹³	5	< 0.1%
7.9749668 × 10¹²	1	< 0.1%
4.6401 × 10¹²	1	< 0.1%
4 × 10¹²	1	< 0.1%
2.0505 × 10¹²	1	< 0.1%
1.50022635 × 10¹²	1	< 0.1%
1.428 × 10¹²	6	< 0.1%
1.25329246 × 10¹²	1	< 0.1%
9.664 × 10¹¹	1	< 0.1%

Saldo Vigencia
Real number (ℝ)

SKEWED ZEROS

Distinct	2206
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.012015 × 10⁸

Minimum	0
Maximum	2.1170079 × 10¹²
Zeros	234044
Zeros (%)	98.4%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2.1170079 × 10¹²
Range	2.1170079 × 10¹²
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.7606003 × 10¹⁰
Coefficient of variation (CV)	34.455756
Kurtosis	3431.1455
Mean	8.012015 × 10⁸
Median Absolute Deviation (MAD)	0
Skewness	54.941886
Sum	1.9052972 × 10¹⁴
Variance	7.6209141 × 10²⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	234044	98.4%
2.841753891 × 10¹⁰	154	0.1%
2.088844511 × 10¹⁰	45	< 0.1%
1.251082738 × 10¹⁰	45	< 0.1%
4.574000043 × 10¹⁰	37	< 0.1%
2.18715 × 10¹⁰	30	< 0.1%
4660998260	30	< 0.1%
1.471853061 × 10¹¹	28	< 0.1%
1.297436856 × 10¹¹	22	< 0.1%
3.1135462 × 10¹⁰	21	< 0.1%
Other values (2196)	3349	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	234044	98.4%
35185	1	< 0.1%
375000	1	< 0.1%
480000	1	< 0.1%
666667	1	< 0.1%
775727	1	< 0.1%
885462	1	< 0.1%
950004	1	< 0.1%
990000	1	< 0.1%
1000000	1	< 0.1%

Value	Count	Frequency (%)
2.117007936 × 10¹²	13	< 0.1%
1.91006 × 10¹²	3	< 0.1%
1.540093841 × 10¹²	1	< 0.1%
1.484533775 × 10¹²	5	< 0.1%
1.476728188 × 10¹²	1	< 0.1%
1.476449418 × 10¹²	4	< 0.1%
1.467475861 × 10¹²	1	< 0.1%
1.46393365 × 10¹²	6	< 0.1%
1.462497405 × 10¹²	1	< 0.1%
1.460496505 × 10¹²	1	< 0.1%

EsPostConflicto
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No	235667
Si	1717
ND	421

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	475610
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	235667	99.1%
Si	1717	0.7%
ND	421	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	235667	99.1%
si	1717	0.7%
nd	421	0.2%

Most occurring characters

Value	Count	Frequency (%)
N	236088	49.6%
o	235667	49.6%
S	1717	0.4%
i	1717	0.4%
D	421	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	238226	50.1%
Lowercase Letter	237384	49.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	236088	99.1%
S	1717	0.7%
D	421	0.2%

Lowercase Letter

Value	Count	Frequency (%)
o	235667	99.3%
i	1717	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	475610	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	236088	49.6%
o	235667	49.6%
S	1717	0.4%
i	1717	0.4%
D	421	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	475610	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	236088	49.6%
o	235667	49.6%
S	1717	0.4%
i	1717	0.4%
D	421	0.1%

Destino Gasto
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Inversión	149010
Funcionamiento	88316
No Definido	479

Length

Max length	14
Median length	9
Mean length	10.860928
Min length	9

Characters and Unicode

Total characters	2582783
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Inversión
2nd row	Inversión
3rd row	Inversión
4th row	Funcionamiento
5th row	Inversión

Common Values

Value	Count	Frequency (%)
Inversión	149010	62.7%
Funcionamiento	88316	37.1%
No Definido	479	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
inversión	149010	62.5%
funcionamiento	88316	37.1%
no	479	0.2%
definido	479	0.2%

Most occurring characters

Value	Count	Frequency (%)
n	563447	21.8%
i	326600	12.6%
e	237805	9.2%
o	177590	6.9%
I	149010	5.8%
v	149010	5.8%
r	149010	5.8%
s	149010	5.8%
ó	149010	5.8%
a	88316	3.4%
Other values (10)	443975	17.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2344020	90.8%
Uppercase Letter	238284	9.2%
Space Separator	479	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	563447	24.0%
i	326600	13.9%
e	237805	10.1%
o	177590	7.6%
v	149010	6.4%
r	149010	6.4%
s	149010	6.4%
ó	149010	6.4%
a	88316	3.8%
t	88316	3.8%
Other values (5)	265906	11.3%

Uppercase Letter

Value	Count	Frequency (%)
I	149010	62.5%
F	88316	37.1%
N	479	0.2%
D	479	0.2%

Space Separator

Value	Count	Frequency (%)
	479	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2582304	> 99.9%
Common	479	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	563447	21.8%
i	326600	12.6%
e	237805	9.2%
o	177590	6.9%
I	149010	5.8%
v	149010	5.8%
r	149010	5.8%
s	149010	5.8%
ó	149010	5.8%
a	88316	3.4%
Other values (9)	443496	17.2%

Common

Value	Count	Frequency (%)
	479	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2433773	94.2%
None	149010	5.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	563447	23.2%
i	326600	13.4%
e	237805	9.8%
o	177590	7.3%
I	149010	6.1%
v	149010	6.1%
r	149010	6.1%
s	149010	6.1%
a	88316	3.6%
t	88316	3.6%
Other values (9)	355659	14.6%

None

Value	Count	Frequency (%)
ó	149010	100.0%

Origen de los Recursos
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

Distribuido	187251
Recursos Propios	50554

Length

Max length	16
Median length	11
Mean length	12.06293
Min length	11

Characters and Unicode

Total characters	2868625
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Distribuido
2nd row	Distribuido
3rd row	Recursos Propios
4th row	Distribuido
5th row	Distribuido

Common Values

Value	Count	Frequency (%)
Distribuido	187251	78.7%
Recursos Propios	50554	21.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
distribuido	187251	64.9%
recursos	50554	17.5%
propios	50554	17.5%

Most occurring characters

Value	Count	Frequency (%)
i	612307	21.3%
s	338913	11.8%
o	338913	11.8%
r	288359	10.1%
u	237805	8.3%
D	187251	6.5%
t	187251	6.5%
b	187251	6.5%
d	187251	6.5%
R	50554	1.8%
Other values (5)	252770	8.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2529712	88.2%
Uppercase Letter	288359	10.1%
Space Separator	50554	1.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	612307	24.2%
s	338913	13.4%
o	338913	13.4%
r	288359	11.4%
u	237805	9.4%
t	187251	7.4%
b	187251	7.4%
d	187251	7.4%
e	50554	2.0%
c	50554	2.0%

Uppercase Letter

Value	Count	Frequency (%)
D	187251	64.9%
R	50554	17.5%
P	50554	17.5%

Space Separator

Value	Count	Frequency (%)
	50554	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2818071	98.2%
Common	50554	1.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	612307	21.7%
s	338913	12.0%
o	338913	12.0%
r	288359	10.2%
u	237805	8.4%
D	187251	6.6%
t	187251	6.6%
b	187251	6.6%
d	187251	6.6%
R	50554	1.8%
Other values (4)	202216	7.2%

Common

Value	Count	Frequency (%)
	50554	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2868625	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	612307	21.3%
s	338913	11.8%
o	338913	11.8%
r	288359	10.1%
u	237805	8.3%
D	187251	6.5%
t	187251	6.5%
b	187251	6.5%
d	187251	6.5%
R	50554	1.8%
Other values (5)	252770	8.8%

Dias Adicionados
Real number (ℝ)

SKEWED ZEROS

Distinct	280
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.1061037

Minimum	0
Maximum	365334
Zeros	203441
Zeros (%)	85.5%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	61
Maximum	365334
Range	365334
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	749.5589
Coefficient of variation (CV)	82.313899
Kurtosis	237290.48
Mean	9.1061037
Median Absolute Deviation (MAD)	0
Skewness	486.86153
Sum	2165477
Variance	561838.55
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	203441	85.5%
31	3827	1.6%
61	2612	1.1%
30	2566	1.1%
92	1879	0.8%
91	1276	0.5%
15	1099	0.5%
60	964	0.4%
62	847	0.4%
29	597	0.3%
Other values (270)	18697	7.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	203441	85.5%
1	446	0.2%
2	264	0.1%
3	210	0.1%
4	222	0.1%
5	247	0.1%
6	277	0.1%
7	296	0.1%
8	301	0.1%
9	302	0.1%

Value	Count	Frequency (%)
365334	1	< 0.1%
3378	1	< 0.1%
457	2	< 0.1%
442	1	< 0.1%
427	1	< 0.1%
423	1	< 0.1%
409	1	< 0.1%
395	1	< 0.1%
368	1	< 0.1%
365	35	< 0.1%

Nacionalidad Representante Legal
Text

Distinct	749
Distinct (%)	0.3%
Missing	5
Missing (%)	< 0.1%
Memory size	3.6 MiB

Length

Max length	46
Median length	10
Mean length	9.8803028
Min length	2

Characters and Unicode

Total characters	2349536
Distinct characters	69
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	353 ?
Unique (%)	0.1%

Sample

1st row	COLOMBIA
2nd row	COLOMBIANO
3rd row	Colombiana
4th row	colombiano
5th row	COLOMBIA

Value	Count	Frequency (%)
colombiana	132384	54.0%
colombiano	63916	26.1%
colombia	31678	12.9%
sin	7111	2.9%
descripcion	7111	2.9%
colombina	175	0.1%
venezolana	113	< 0.1%
colobiana	107	< 0.1%
venezolano	77	< 0.1%
colmbiana	72	< 0.1%
Other values (555)	2478	1.0%

Most occurring characters

Value	Count	Frequency (%)
O	268700	11.4%
o	262866	11.2%
A	186989	8.0%
C	185495	7.9%
a	177691	7.6%
i	134122	5.7%
L	117473	5.0%
I	117381	5.0%
B	117252	5.0%
M	117069	5.0%
Other values (59)	664498	28.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1230449	52.4%
Lowercase Letter	1111128	47.3%
Space Separator	7447	0.3%
Decimal Number	512	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	262866	23.7%
a	177691	16.0%
i	134122	12.1%
l	112779	10.1%
b	112547	10.1%
m	112492	10.1%
n	109514	9.9%
c	58806	5.3%
e	7588	0.7%
r	7361	0.7%
Other values (21)	15362	1.4%

Uppercase Letter

Value	Count	Frequency (%)
O	268700	21.8%
A	186989	15.2%
C	185495	15.1%
L	117473	9.5%
I	117381	9.5%
B	117252	9.5%
M	117069	9.5%
N	103621	8.4%
S	7317	0.6%
D	7227	0.6%
Other values (17)	1925	0.2%

Decimal Number

Value	Count	Frequency (%)
0	88	17.2%
1	82	16.0%
3	55	10.7%
5	50	9.8%
6	46	9.0%
2	41	8.0%
8	39	7.6%
7	39	7.6%
9	38	7.4%
4	34	6.6%

Space Separator

Value	Count	Frequency (%)
	7447	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2341577	99.7%
Common	7959	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	268700	11.5%
o	262866	11.2%
A	186989	8.0%
C	185495	7.9%
a	177691	7.6%
i	134122	5.7%
L	117473	5.0%
I	117381	5.0%
B	117252	5.0%
M	117069	5.0%
Other values (48)	656539	28.0%

Common

Value	Count	Frequency (%)
	7447	93.6%
0	88	1.1%
1	82	1.0%
3	55	0.7%
5	50	0.6%
6	46	0.6%
2	41	0.5%
8	39	0.5%
7	39	0.5%
9	38	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2349390	> 99.9%
None	146	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	268700	11.4%
o	262866	11.2%
A	186989	8.0%
C	185495	7.9%
a	177691	7.6%
i	134122	5.7%
L	117473	5.0%
I	117381	5.0%
B	117252	5.0%
M	117069	5.0%
Other values (51)	664352	28.3%

None

Value	Count	Frequency (%)
Ñ	89	61.0%
ñ	31	21.2%
á	15	10.3%
ô	3	2.1%
é	3	2.1%
í	3	2.1%
Á	1	0.7%
ú	1	0.7%

Género Representante Legal
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.6 MiB

No Definido	112298
Mujer	66134
Hombre	59026
Otro	347

Length

Max length	11
Median length	6
Mean length	8.0801161
Min length	4

Characters and Unicode

Total characters	1921492
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hombre
2nd row	Hombre
3rd row	Mujer
4th row	Hombre
5th row	Hombre

Common Values

Value	Count	Frequency (%)
No Definido	112298	47.2%
Mujer	66134	27.8%
Hombre	59026	24.8%
Otro	347	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	112298	32.1%
definido	112298	32.1%
mujer	66134	18.9%
hombre	59026	16.9%
otro	347	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	283969	14.8%
e	237458	12.4%
i	224596	11.7%
r	125507	6.5%
N	112298	5.8%
	112298	5.8%
D	112298	5.8%
f	112298	5.8%
n	112298	5.8%
d	112298	5.8%
Other values (8)	376174	19.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1459091	75.9%
Uppercase Letter	350103	18.2%
Space Separator	112298	5.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	283969	19.5%
e	237458	16.3%
i	224596	15.4%
r	125507	8.6%
f	112298	7.7%
n	112298	7.7%
d	112298	7.7%
j	66134	4.5%
u	66134	4.5%
m	59026	4.0%
Other values (2)	59373	4.1%

Uppercase Letter

Value	Count	Frequency (%)
N	112298	32.1%
D	112298	32.1%
M	66134	18.9%
H	59026	16.9%
O	347	0.1%

Space Separator

Value	Count	Frequency (%)
	112298	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1809194	94.2%
Common	112298	5.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	283969	15.7%
e	237458	13.1%
i	224596	12.4%
r	125507	6.9%
N	112298	6.2%
D	112298	6.2%
f	112298	6.2%
n	112298	6.2%
d	112298	6.2%
j	66134	3.7%
Other values (7)	310040	17.1%

Common

Value	Count	Frequency (%)
	112298	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1921492	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	283969	14.8%
e	237458	12.4%
i	224596	11.7%
r	125507	6.5%
N	112298	5.8%
	112298	5.8%
D	112298	5.8%
f	112298	5.8%
n	112298	5.8%
d	112298	5.8%
Other values (8)	376174	19.6%

Presupuesto General de la Nacion – PGN
Real number (ℝ)

SKEWED ZEROS

Distinct	26991
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49672739

Minimum	0
Maximum	8.612227 × 10¹¹
Zeros	186497
Zeros (%)	78.4%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	57376282
Maximum	8.612227 × 10¹¹
Range	8.612227 × 10¹¹
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.7020287 × 10⁹
Coefficient of variation (CV)	54.396613
Kurtosis	60681.287
Mean	49672739
Median Absolute Deviation (MAD)	0
Skewness	225.67553
Sum	1.1812426 × 10¹³
Variance	7.3009594 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	186497	78.4%
30210840	249	0.1%
20000000	215	0.1%
30000000	210	0.1%
24000000	196	0.1%
18000000	164	0.1%
12000000	159	0.1%
15000000	153	0.1%
28000000	146	0.1%
40000000	134	0.1%
Other values (26981)	49682	20.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	186497	78.4%
1	2	< 0.1%
22262	1	< 0.1%
31000	1	< 0.1%
75291	1	< 0.1%
93016	1	< 0.1%
100000	1	< 0.1%
142450	1	< 0.1%
192200	1	< 0.1%
205000	1	< 0.1%

Value	Count	Frequency (%)
8.61222696 × 10¹¹	1	< 0.1%
6.300077483 × 10¹¹	1	< 0.1%
4.547759218 × 10¹¹	1	< 0.1%
3.19366761 × 10¹¹	1	< 0.1%
2.231804056 × 10¹¹	1	< 0.1%
2.126830241 × 10¹¹	1	< 0.1%
2.11033526 × 10¹¹	1	< 0.1%
2.05923159 × 10¹¹	1	< 0.1%
9.006472657 × 10¹⁰	1	< 0.1%
8 × 10¹⁰	1	< 0.1%

Sistema General de Participaciones
Real number (ℝ)

SKEWED ZEROS

Distinct	4653
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4812445.2

Minimum	0
Maximum	6.3356333 × 10¹⁰
Zeros	226862
Zeros (%)	95.4%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6.3356333 × 10¹⁰
Range	6.3356333 × 10¹⁰
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.1274757 × 10⁸
Coefficient of variation (CV)	44.207791
Kurtosis	39939.011
Mean	4812445.2
Median Absolute Deviation (MAD)	0
Skewness	167.48456
Sum	1.1444235 × 10¹²
Variance	4.5261529 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	226862	95.4%
12000000	138	0.1%
18000000	138	0.1%
6000000	110	< 0.1%
10000000	110	< 0.1%
21600000	98	< 0.1%
9000000	97	< 0.1%
10800000	96	< 0.1%
14000000	86	< 0.1%
24000000	83	< 0.1%
Other values (4643)	9987	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	226862	95.4%
30100	1	< 0.1%
54619	1	< 0.1%
99120	1	< 0.1%
142800	1	< 0.1%
235620	1	< 0.1%
242150	1	< 0.1%
243950	1	< 0.1%
300000	1	< 0.1%
302516	1	< 0.1%

Value	Count	Frequency (%)
6.335633259 × 10¹⁰	1	< 0.1%
3.251915806 × 10¹⁰	1	< 0.1%
3.249637415 × 10¹⁰	1	< 0.1%
2.75 × 10¹⁰	1	< 0.1%
2.16158336 × 10¹⁰	1	< 0.1%
1.570363687 × 10¹⁰	1	< 0.1%
1.495230124 × 10¹⁰	1	< 0.1%
1.338566467 × 10¹⁰	1	< 0.1%
1.330661797 × 10¹⁰	1	< 0.1%
1.265365792 × 10¹⁰	1	< 0.1%

Sistema General de Regalías
Real number (ℝ)

SKEWED ZEROS

Distinct	1580
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4292306.6

Minimum	0
Maximum	6.2707126 × 10¹⁰
Zeros	235635
Zeros (%)	99.1%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6.2707126 × 10¹⁰
Range	6.2707126 × 10¹⁰
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.7991602 × 10⁸
Coefficient of variation (CV)	65.213425
Kurtosis	23939.198
Mean	4292306.6
Median Absolute Deviation (MAD)	0
Skewness	138.5649
Sum	1.020732 × 10¹²
Variance	7.8352978 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	235635	99.1%
50000000	26	< 0.1%
41815126	19	< 0.1%
24000000	16	< 0.1%
15000000	14	< 0.1%
9000000	14	< 0.1%
90000000	14	< 0.1%
20000000	13	< 0.1%
16000000	12	< 0.1%
36000000	11	< 0.1%
Other values (1570)	2031	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	235635	99.1%
201348	1	< 0.1%
243000	1	< 0.1%
277508	1	< 0.1%
291325	1	< 0.1%
464100	1	< 0.1%
511700	1	< 0.1%
600000	1	< 0.1%
672298	1	< 0.1%
966100	1	< 0.1%

Value	Count	Frequency (%)
6.270712637 × 10¹⁰	1	< 0.1%
5.438763671 × 10¹⁰	1	< 0.1%
4.49056133 × 10¹⁰	1	< 0.1%
4.057312922 × 10¹⁰	1	< 0.1%
3.630953781 × 10¹⁰	1	< 0.1%
3.004220165 × 10¹⁰	1	< 0.1%
2.315727523 × 10¹⁰	1	< 0.1%
2.258663125 × 10¹⁰	1	< 0.1%
2.078511343 × 10¹⁰	1	< 0.1%
1.865689912 × 10¹⁰	1	< 0.1%

Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)
Real number (ℝ)

SKEWED ZEROS

Distinct	34433
Distinct (%)	14.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.3897364 × 10⁸

Minimum	0
Maximum	1.4207686 × 10¹⁴
Zeros	116337
Zeros (%)	48.9%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2400000
Q3	16371000
95-th percentile	56000000
Maximum	1.4207686 × 10¹⁴
Range	1.4207686 × 10¹⁴
Interquartile range (IQR)	16371000

Descriptive statistics

Standard deviation	2.9135132 × 10¹¹
Coefficient of variation (CV)	455.96767
Kurtosis	237795.69
Mean	6.3897364 × 10⁸
Median Absolute Deviation (MAD)	2400000
Skewness	487.63824
Sum	1.5195113 × 10¹⁴
Variance	8.4885593 × 10²²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	116337	48.9%
12000000	1714	0.7%
9000000	1300	0.5%
18000000	1281	0.5%
6000000	1087	0.5%
10000000	1058	0.4%
15000000	1013	0.4%
14000000	987	0.4%
8000000	986	0.4%
21000000	935	0.4%
Other values (34423)	111107	46.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	116337	48.9%
1	14	< 0.1%
3000	1	< 0.1%
3703	1	< 0.1%
7676	1	< 0.1%
10000	1	< 0.1%
16824	1	< 0.1%
18674	1	< 0.1%
46470	1	< 0.1%
85400	1	< 0.1%

Value	Count	Frequency (%)
1.420768642 × 10¹⁴	1	< 0.1%
3.448830208 × 10¹¹	1	< 0.1%
3.190473682 × 10¹¹	1	< 0.1%
2.202424716 × 10¹¹	1	< 0.1%
2.021478 × 10¹¹	1	< 0.1%
1.239773493 × 10¹¹	1	< 0.1%
7.059183664 × 10¹⁰	1	< 0.1%
6.884904898 × 10¹⁰	1	< 0.1%
5.858519574 × 10¹⁰	1	< 0.1%
5.461379556 × 10¹⁰	1	< 0.1%

Recursos de Credito
Real number (ℝ)

SKEWED ZEROS

Distinct	600
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4640038.2

Minimum	0
Maximum	1 × 10¹¹
Zeros	237029
Zeros (%)	99.7%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1 × 10¹¹
Range	1 × 10¹¹
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.9824754 × 10⁸
Coefficient of variation (CV)	85.828506
Kurtosis	31629.839
Mean	4640038.2
Median Absolute Deviation (MAD)	0
Skewness	159.55737
Sum	1.1034243 × 10¹²
Variance	1.5860111 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	237029	99.7%
3642000	24	< 0.1%
40000000	10	< 0.1%
9870000	10	< 0.1%
19650000	9	< 0.1%
27510000	7	< 0.1%
19554000	7	< 0.1%
6739833	6	< 0.1%
4368000	5	< 0.1%
5000000	5	< 0.1%
Other values (590)	693	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	237029	99.7%
325000	1	< 0.1%
924420	1	< 0.1%
1000000	1	< 0.1%
1057809	1	< 0.1%
1440000	1	< 0.1%
1500000	1	< 0.1%
1586714	1	< 0.1%
1764730	1	< 0.1%
1800000	1	< 0.1%

Value	Count	Frequency (%)
1 × 10¹¹	1	< 0.1%
8.7 × 10¹⁰	1	< 0.1%
5.662034 × 10¹⁰	1	< 0.1%
4.9 × 10¹⁰	1	< 0.1%
4.5 × 10¹⁰	1	< 0.1%
4.335985846 × 10¹⁰	1	< 0.1%
4.2 × 10¹⁰	1	< 0.1%
3.414566186 × 10¹⁰	1	< 0.1%
3.386 × 10¹⁰	1	< 0.1%
3.328558224 × 10¹⁰	1	< 0.1%

Recursos Propios
Real number (ℝ)

SKEWED ZEROS

Distinct	24742
Distinct (%)	10.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25331267

Minimum	0
Maximum	1.9880246 × 10¹¹
Zeros	185428
Zeros (%)	78.0%
Negative	0
Negative (%)	0.0%
Memory size	3.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	43400000
Maximum	1.9880246 × 10¹¹
Range	1.9880246 × 10¹¹
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.3922992 × 10⁸
Coefficient of variation (CV)	33.130199
Kurtosis	26710.205
Mean	25331267
Median Absolute Deviation (MAD)	0
Skewness	137.3735
Sum	6.023902 × 10¹²
Variance	7.0430685 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	185428	78.0%
12000000	394	0.2%
9000000	355	0.1%
10000000	355	0.1%
15000000	340	0.1%
6000000	317	0.1%
18000000	288	0.1%
24000000	284	0.1%
20000000	276	0.1%
30000000	268	0.1%
Other values (24732)	49500	20.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	185428	78.0%
1	7	< 0.1%
11090	1	< 0.1%
16000	1	< 0.1%
26386	1	< 0.1%
29000	1	< 0.1%
54000	1	< 0.1%
70000	1	< 0.1%
94087	4	< 0.1%
100000	1	< 0.1%

Value	Count	Frequency (%)
1.988024598 × 10¹¹	1	< 0.1%
1.896624457 × 10¹¹	1	< 0.1%
9.468352547 × 10¹⁰	1	< 0.1%
8.042395266 × 10¹⁰	1	< 0.1%
7.48008191 × 10¹⁰	1	< 0.1%
7.233468206 × 10¹⁰	1	< 0.1%
6.934623875 × 10¹⁰	1	< 0.1%
6.240813326 × 10¹⁰	1	< 0.1%
5.785096986 × 10¹⁰	1	< 0.1%
5.391560575 × 10¹⁰	1	< 0.1%

Fecha Inicio Liquidacion
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	237805
Missing (%)	100.0%
Memory size	3.6 MiB

Fecha Fin Liquidacion
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	237805
Missing (%)	100.0%
Memory size	3.6 MiB

Auto

Heatmap
Table

	Nit Entidad	Valor del Contrato	Valor de pago adelantado	Valor Facturado	Valor Pendiente de Pago	Valor Pagado	Valor Amortizado	Valor Pendiente de Amortizacion	Valor Pendiente de Ejecucion	Saldo CDP	Saldo Vigencia	Dias Adicionados	Presupuesto General de la Nacion – PGN	Sistema General de Participaciones	Sistema General de Regalías	Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)	Recursos de Credito	Recursos Propios	Departamento	Orden	Sector	Rama	Entidad Centralizada	Estado Contrato	Tipo de Contrato	Modalidad de Contratacion	Condiciones de Entrega	TipoDocProveedor	Es Grupo	Es Pyme	Habilita Pago Adelantado	Liquidación	Obligación Ambiental	Obligaciones Postconsumo	Reversion	EsPostConflicto	Destino Gasto	Origen de los Recursos	Género Representante Legal
Nit Entidad	1.000	0.190	-0.005	0.027	0.120	0.044	-0.006	-0.004	0.121	0.163	0.031	0.104	0.155	-0.030	0.017	-0.089	0.007	0.057	0.262	0.059	0.263	0.016	0.084	0.059	0.030	0.055	0.039	0.018	0.011	0.016	0.000	0.041	0.047	0.004	0.000	0.019	0.011	0.023	0.028
Valor del Contrato	0.190	1.000	0.036	0.262	0.633	0.179	0.013	0.033	0.639	0.512	0.103	0.126	0.319	-0.022	0.047	0.090	0.030	0.079	0.000	0.000	0.000	0.003	0.000	0.002	0.000	0.000	0.000	0.000	0.000	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Valor de pago adelantado	-0.005	0.036	1.000	0.002	0.029	-0.004	0.376	0.942	0.029	0.017	0.000	-0.001	-0.012	0.013	0.021	0.005	-0.002	0.015	0.015	0.000	0.000	0.000	0.000	0.018	0.025	0.055	0.000	0.019	0.057	0.001	0.116	0.012	0.016	0.000	0.000	0.000	0.000	0.000	0.000
Valor Facturado	0.027	0.262	0.002	1.000	-0.329	0.807	0.017	-0.003	-0.335	0.137	-0.033	0.088	0.183	0.021	-0.011	-0.017	0.009	-0.053	0.000	0.000	0.000	0.000	0.011	0.004	0.016	0.042	0.000	0.008	0.064	0.000	0.000	0.016	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Valor Pendiente de Pago	0.120	0.633	0.029	-0.329	1.000	-0.510	-0.005	0.032	1.000	0.337	0.113	0.019	0.144	-0.016	0.050	0.081	0.026	0.090	0.000	0.000	0.005	0.000	0.006	0.000	0.062	0.038	0.000	0.015	0.064	0.000	0.000	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Valor Pagado	0.044	0.179	-0.004	0.807	-0.510	1.000	0.019	-0.010	-0.516	0.073	-0.029	0.076	0.163	-0.001	-0.017	-0.034	-0.002	-0.040	0.000	0.000	0.000	0.000	0.011	0.000	0.011	0.035	0.000	0.005	0.055	0.003	0.000	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Valor Amortizado	-0.006	0.013	0.376	0.017	-0.005	0.019	1.000	0.095	-0.005	0.006	-0.001	0.000	-0.003	0.004	0.003	0.002	-0.001	0.007	0.009	0.018	0.000	0.004	0.000	0.000	0.017	0.015	0.000	0.000	0.033	0.006	0.169	0.005	0.000	0.000	0.000	0.000	0.000	0.007	0.000
Valor Pendiente de Amortizacion	-0.004	0.033	0.942	-0.003	0.032	-0.010	0.095	1.000	0.032	0.016	0.001	-0.000	-0.011	0.012	0.020	0.005	-0.001	0.014	0.015	0.000	0.000	0.000	0.000	0.018	0.025	0.055	0.000	0.019	0.057	0.001	0.116	0.012	0.016	0.000	0.000	0.000	0.000	0.000	0.000
Valor Pendiente de Ejecucion	0.121	0.639	0.029	-0.335	1.000	-0.516	-0.005	0.032	1.000	0.340	0.113	0.019	0.145	-0.016	0.050	0.082	0.027	0.090	0.000	0.000	0.005	0.000	0.006	0.000	0.062	0.038	0.000	0.015	0.064	0.000	0.000	0.010	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Saldo CDP	0.163	0.512	0.017	0.137	0.337	0.073	0.006	0.016	0.340	1.000	0.022	0.091	0.243	-0.029	0.024	0.024	0.019	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Saldo Vigencia	0.031	0.103	0.000	-0.033	0.113	-0.029	-0.001	0.001	0.113	0.022	1.000	0.020	0.120	-0.017	-0.003	-0.057	0.008	0.010	0.033	0.028	0.031	0.053	0.008	0.006	0.042	0.049	0.002	0.021	0.026	0.011	0.000	0.059	0.006	0.000	0.000	0.000	0.013	0.009	0.011
Dias Adicionados	0.104	0.126	-0.001	0.088	0.019	0.076	0.000	-0.000	0.019	0.091	0.020	1.000	0.027	0.004	0.002	-0.008	0.003	0.053	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.006	0.000	0.000	0.000	0.000	0.000	0.000
Presupuesto General de la Nacion – PGN	0.155	0.319	-0.012	0.183	0.144	0.163	-0.003	-0.011	0.145	0.243	0.120	0.027	1.000	-0.111	-0.038	-0.485	-0.023	-0.249	0.000	0.004	0.001	0.000	0.002	0.000	0.019	0.040	0.000	0.007	0.077	0.000	0.000	0.006	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Sistema General de Participaciones	-0.030	-0.022	0.013	0.021	-0.016	-0.001	0.004	0.012	-0.016	-0.029	-0.017	0.004	-0.111	1.000	-0.019	-0.180	-0.009	-0.108	0.013	0.000	0.000	0.000	0.013	0.013	0.000	0.032	0.000	0.009	0.024	0.000	0.000	0.009	0.000	0.000	0.000	0.000	0.000	0.001	0.000
Sistema General de Regalías	0.017	0.047	0.021	-0.011	0.050	-0.017	0.003	0.020	0.050	0.024	-0.003	0.002	-0.038	-0.019	1.000	-0.088	-0.003	-0.047	0.011	0.000	0.000	0.000	0.000	0.022	0.026	0.068	0.000	0.022	0.096	0.011	0.014	0.015	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)	-0.089	0.090	0.005	-0.017	0.081	-0.034	0.002	0.005	0.082	0.024	-0.057	-0.008	-0.485	-0.180	-0.088	1.000	-0.045	-0.472	0.000	0.000	0.000	0.003	0.000	0.002	0.000	0.000	0.000	0.000	0.000	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
Recursos de Credito	0.007	0.030	-0.002	0.009	0.026	-0.002	-0.001	-0.001	0.027	0.019	0.008	0.003	-0.023	-0.009	-0.003	-0.045	1.000	-0.026	0.000	0.000	0.014	0.000	0.000	0.003	0.158	0.031	0.109	0.016	0.059	0.000	0.000	0.010	0.005	0.060	0.000	0.000	0.000	0.000	0.003
Recursos Propios	0.057	0.079	0.015	-0.053	0.090	-0.040	0.007	0.014	0.090	0.002	0.010	0.053	-0.249	-0.108	-0.047	-0.472	-0.026	1.000	0.000	0.005	0.010	0.000	0.006	0.000	0.032	0.052	0.000	0.027	0.073	0.000	0.000	0.019	0.000	0.000	0.000	0.000	0.002	0.024	0.006
Departamento	0.262	0.000	0.015	0.000	0.000	0.000	0.009	0.015	0.000	0.000	0.033	0.000	0.000	0.013	0.011	0.000	0.000	0.000	1.000	0.279	0.173	0.120	0.290	0.135	0.035	0.058	0.127	0.047	0.038	0.081	0.049	0.226	0.138	0.028	0.014	0.080	0.141	0.213	0.142
Orden	0.059	0.000	0.000	0.000	0.000	0.000	0.018	0.000	0.000	0.000	0.028	0.000	0.004	0.000	0.000	0.000	0.000	0.005	0.279	1.000	0.582	0.242	0.143	0.070	0.092	0.099	0.102	0.039	0.012	0.051	0.012	0.021	0.148	0.027	0.006	0.086	0.039	0.230	0.114
Sector	0.263	0.000	0.000	0.000	0.005	0.000	0.000	0.000	0.005	0.000	0.031	0.000	0.001	0.000	0.000	0.000	0.014	0.010	0.173	0.582	1.000	0.361	0.350	0.091	0.084	0.183	0.125	0.059	0.037	0.125	0.020	0.212	0.348	0.070	0.011	0.355	0.329	0.451	0.126
Rama	0.016	0.003	0.000	0.000	0.000	0.000	0.004	0.000	0.000	0.000	0.053	0.000	0.000	0.000	0.000	0.003	0.000	0.000	0.120	0.242	0.361	1.000	0.054	0.018	0.154	0.146	0.066	0.051	0.013	0.062	0.006	0.105	0.069	0.014	0.000	0.011	0.182	0.328	0.049
Entidad Centralizada	0.084	0.000	0.000	0.011	0.006	0.011	0.000	0.000	0.006	0.000	0.008	0.000	0.002	0.013	0.000	0.000	0.000	0.006	0.290	0.143	0.350	0.054	1.000	0.036	0.086	0.150	0.099	0.020	0.014	0.035	0.006	0.009	0.076	0.012	0.000	0.015	0.062	0.185	0.051
Estado Contrato	0.059	0.002	0.018	0.004	0.000	0.000	0.000	0.018	0.000	0.000	0.006	0.000	0.000	0.013	0.022	0.002	0.003	0.000	0.135	0.070	0.091	0.018	0.036	1.000	0.067	0.089	0.035	0.035	0.109	0.052	0.017	0.047	0.028	0.005	0.008	0.028	0.059	0.049	0.051
Tipo de Contrato	0.030	0.000	0.025	0.016	0.062	0.011	0.017	0.025	0.062	0.000	0.042	0.000	0.019	0.000	0.026	0.000	0.158	0.032	0.035	0.092	0.084	0.154	0.086	0.067	1.000	0.573	0.030	0.246	0.418	0.368	0.313	0.283	0.038	0.023	0.010	0.011	0.279	0.153	0.110
Modalidad de Contratacion	0.055	0.000	0.055	0.042	0.038	0.035	0.015	0.055	0.038	0.000	0.049	0.000	0.040	0.032	0.068	0.000	0.031	0.052	0.058	0.099	0.183	0.146	0.150	0.089	0.573	1.000	0.042	0.253	0.551	0.468	0.161	0.317	0.061	0.034	0.003	0.012	0.353	0.336	0.114
Condiciones de Entrega	0.039	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	0.000	0.000	0.000	0.000	0.000	0.109	0.000	0.127	0.102	0.125	0.066	0.099	0.035	0.030	0.042	1.000	0.024	0.029	0.061	0.001	0.122	0.312	0.054	0.005	0.040	0.042	0.101	0.041
TipoDocProveedor	0.018	0.000	0.019	0.008	0.015	0.005	0.000	0.019	0.015	0.000	0.021	0.000	0.007	0.009	0.022	0.000	0.016	0.027	0.047	0.039	0.059	0.051	0.020	0.035	0.246	0.253	0.024	1.000	0.395	0.390	0.036	0.325	0.004	0.014	0.003	0.009	0.061	0.010	0.144
Es Grupo	0.011	0.000	0.057	0.064	0.064	0.055	0.033	0.057	0.064	0.000	0.026	0.000	0.077	0.024	0.096	0.000	0.059	0.073	0.038	0.012	0.037	0.013	0.014	0.109	0.418	0.551	0.029	0.395	1.000	0.023	0.037	0.100	0.008	0.000	0.000	0.000	0.020	0.000	0.063
Es Pyme	0.016	0.001	0.001	0.000	0.000	0.003	0.006	0.001	0.000	0.000	0.011	0.000	0.000	0.000	0.011	0.001	0.000	0.000	0.081	0.051	0.125	0.062	0.035	0.052	0.368	0.468	0.061	0.390	0.023	1.000	0.021	0.153	0.039	0.011	0.003	0.015	0.050	0.000	0.160
Habilita Pago Adelantado	0.000	0.000	0.116	0.000	0.000	0.000	0.169	0.116	0.000	0.000	0.000	0.000	0.000	0.000	0.014	0.000	0.000	0.000	0.049	0.012	0.020	0.006	0.006	0.017	0.313	0.161	0.001	0.036	0.037	0.021	1.000	0.016	0.007	0.008	0.000	0.002	0.008	0.010	0.000
Liquidación	0.041	0.000	0.012	0.016	0.010	0.014	0.005	0.012	0.010	0.000	0.059	0.000	0.006	0.009	0.015	0.000	0.010	0.019	0.226	0.021	0.212	0.105	0.009	0.047	0.283	0.317	0.122	0.325	0.100	0.153	0.016	1.000	0.039	0.014	0.015	0.012	0.066	0.036	0.077
Obligación Ambiental	0.047	0.000	0.016	0.000	0.000	0.000	0.000	0.016	0.000	0.000	0.006	0.006	0.000	0.000	0.000	0.000	0.005	0.000	0.138	0.148	0.348	0.069	0.076	0.028	0.038	0.061	0.312	0.004	0.008	0.039	0.007	0.039	1.000	0.087	0.007	0.012	0.074	0.020	0.058
Obligaciones Postconsumo	0.004	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.060	0.000	0.028	0.027	0.070	0.014	0.012	0.005	0.023	0.034	0.054	0.014	0.000	0.011	0.008	0.014	0.087	1.000	0.040	0.000	0.018	0.009	0.007
Reversion	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.014	0.006	0.011	0.000	0.000	0.008	0.010	0.003	0.005	0.003	0.000	0.003	0.000	0.015	0.007	0.040	1.000	0.000	0.000	0.000	0.000
EsPostConflicto	0.019	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.080	0.086	0.355	0.011	0.015	0.028	0.011	0.012	0.040	0.009	0.000	0.015	0.002	0.012	0.012	0.000	0.000	1.000	0.663	0.049	0.010
Destino Gasto	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.013	0.000	0.000	0.000	0.000	0.000	0.000	0.002	0.141	0.039	0.329	0.182	0.062	0.059	0.279	0.353	0.042	0.061	0.020	0.050	0.008	0.066	0.074	0.018	0.000	0.663	1.000	0.187	0.032
Origen de los Recursos	0.023	0.000	0.000	0.000	0.000	0.000	0.007	0.000	0.000	0.000	0.009	0.000	0.000	0.001	0.000	0.000	0.000	0.024	0.213	0.230	0.451	0.328	0.185	0.049	0.153	0.336	0.101	0.010	0.000	0.000	0.010	0.036	0.020	0.009	0.000	0.049	0.187	1.000	0.049
Género Representante Legal	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.011	0.000	0.000	0.000	0.000	0.000	0.003	0.006	0.142	0.114	0.126	0.049	0.051	0.051	0.110	0.114	0.041	0.144	0.063	0.160	0.000	0.077	0.058	0.007	0.000	0.010	0.032	0.049	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Nombre Entidad	Nit Entidad	Departamento	Ciudad	Localización	Orden	Sector	Rama	Entidad Centralizada	Estado Contrato	Tipo de Contrato	Modalidad de Contratacion	Fecha de Firma	Fecha de Inicio del Contrato	Fecha de Fin del Contrato	Fecha de Inicio de Ejecucion	Fecha de Fin de Ejecucion	Condiciones de Entrega	TipoDocProveedor	Es Grupo	Es Pyme	Habilita Pago Adelantado	Liquidación	Obligación Ambiental	Obligaciones Postconsumo	Reversion	Valor del Contrato	Valor Facturado	Valor Pendiente de Pago	Valor Pagado	Valor Pendiente de Ejecucion	Saldo CDP	EsPostConflicto	Destino Gasto	Origen de los Recursos	Nacionalidad Representante Legal	Género Representante Legal	Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)	Recursos Propios	Fecha Inicio Liquidacion	Fecha Fin Liquidacion
402347	UNIDAD EJECUTORA DE SANEAMIENTO DEL VALLE DEL CAUCA	805018833	Valle del Cauca	Cali	Colombia, Valle del Cauca , Cali	Territorial	Salud y Protección Social	Ejecutivo	Centralizada	En ejecución	Prestación de servicios	Contratación directa	2023-02-19	2023-02-20	2023-07-31	NaT	NaT	A convenir	Cédula de Ciudadanía	No	No	No	No	No	No	No	22440000	18700000	7480000	14960000	7480000.0	22440000	No	Inversión	Distribuido	COLOMBIA	Hombre	22440000	0	NaT	NaT
1743815	Secretaría de Gobierno Convivencia y Seguridad Alcaldía de Tuluá	891900272	Valle del Cauca	Tuluá	Colombia, Valle del Cauca , Tuluá	Territorial	Servicio Público	Ejecutivo	Descentralizada	En ejecución	Prestación de servicios	Contratación directa	2022-09-29	2022-10-08	2022-12-15	NaT	NaT	A convenir	Cédula de Ciudadanía	No	No	No	No	No	No	No	6450000	0	6450000	0	6450000.0	206400000	No	Inversión	Distribuido	COLOMBIANO	Hombre	6450000	0	NaT	NaT
88299	SECRETARIA DISTRITAL DE AMBIENTE	899999061	Distrito Capital de Bogotá	Bogotá	Colombia, Bogotá, Bogotá	Territorial	Ambiente y Desarrollo Sostenible	Ejecutivo	Centralizada	Cerrado	Prestación de servicios	Contratación directa	2022-01-16	2022-01-21	2023-02-28	NaT	NaT	A convenir	Cédula de Ciudadanía	No	No	No	No	No	No	No	40133333	40133333	0	40133333	0.0	40133333	No	Inversión	Recursos Propios	Colombiana	Mujer	0	40133333	NaT	NaT
2070712	GOBERNACIÓN DEL DEPARTAMENTO ARCHIPIELAGO DE SAN ANDRES PROVIDENCIA Y SANTA CATALINA	892400038	San Andrés, Providencia y Santa Catalina	San Andrés	Colombia, San Andrés, Providencia y Santa Catalina , San Andrés	Territorial	No aplica/No pertenece	Ejecutivo	Descentralizada	En ejecución	Prestación de servicios	Contratación directa	2022-09-30	2022-09-30	2022-12-29	NaT	NaT	A convenir	Cédula de Ciudadanía	No	No	No	No	No	No	No	12028695	0	12028695	0	12028695.0	16398260	No	Funcionamiento	Distribuido	colombiano	Hombre	12028695	0	NaT	NaT
996719	ALCALDIA MUNICIPAL DE MELGAR	890701933	Tolima	Melgar	Colombia, Tolima , Melgar	Territorial	No aplica/No pertenece	Ejecutivo	Centralizada	En ejecución	Prestación de servicios	Contratación directa	2023-01-20	2023-02-01	2023-05-31	NaT	NaT	Como acordado previamente	Cédula de Ciudadanía	No	No	No	No	No	No	No	5600000	5600000	0	5600000	0.0	5600000	No	Inversión	Distribuido	COLOMBIA	Hombre	5600000	0	NaT	NaT
441346	HMI	802013023	Atlántico	Soledad	Colombia, Atlántico , Soledad	Territorial	Salud y Protección Social	Corporación Autónoma	Descentralizada	En ejecución	DecreeLaw092/2017	Contratación régimen especial	2022-12-19	2022-12-19	2022-12-31	NaT	NaT	Como acordado previamente	Cédula de Ciudadanía	No	No	No	No	No	No	No	3072000	0	3072000	0	3072000.0	3072000	No	Funcionamiento	Recursos Propios	COLOMBIANO	Hombre	0	3072000	NaT	NaT
2359637	ALCALDIA MUNICIPAL DE CAUCASIA	890906445	Antioquia	Caucasia	Colombia, Antioquia , Caucasia	Territorial	No aplica/No pertenece	Ejecutivo	Descentralizada	En ejecución	Prestación de servicios	Contratación directa	2022-10-06	2022-10-06	2022-12-30	NaT	NaT	A convenir	Cédula de Ciudadanía	No	No	No	No	No	No	No	5666666	5666666	5666666	0	5666666.0	6000000	No	Funcionamiento	Distribuido	Colombiana	Mujer	5666666	0	NaT	NaT
1983017	EMPRESAS PÚBLICAS MUNICIPALES DE MALAGA	890205049	Santander	Málaga	Colombia, Santander , Málaga	Territorial	Ambiente y Desarrollo Sostenible	Corporación Autónoma	Descentralizada	En ejecución	Prestación de servicios	Contratación régimen especial	2023-06-05	2023-06-05	2023-12-28	NaT	NaT	A convenir	Cédula de Ciudadanía	No	No	No	No	No	No	No	12754000	1822000	10932000	1822000	10932000.0	12754000	No	Funcionamiento	Recursos Propios	COLOMBIANA	Mujer	0	12754000	NaT	NaT
1100805	MUNICIPIO DE MARINILLA	890983716	Antioquia	Marinilla	Colombia, Antioquia , Marinilla	Nacional	Servicio Público	Ejecutivo	Descentralizada	En ejecución	Prestación de servicios	Contratación directa	2023-05-05	2023-05-05	2023-12-31	NaT	NaT	Como acordado previamente	No Definido	No	No	No	No	No	No	No	49966910	0	49966910	0	49966910.0	49966910	No	Funcionamiento	Distribuido	COLOMBIANO	Hombre	49966910	0	NaT	NaT
1847297	SUBRED INTEGRADA DE SERVICIOS DE SALUD NORTE ESE	900971006	Distrito Capital de Bogotá	No Definido	Colombia, Bogotá, Bogotá	Territorial	Salud y Protección Social	Corporación Autónoma	Descentralizada	En ejecución	DecreeLaw092/2017	Contratación régimen especial	2022-02-17	2022-02-18	2023-12-31	NaT	NaT	A convenir	Cédula de Ciudadanía	No	No	No	No	No	No	No	19226262	0	19226262	0	19226262.0	15576325956	No	Funcionamiento	Recursos Propios	COLOMBIANA	Mujer	0	19226262	NaT	NaT

	Nombre Entidad	Nit Entidad	Departamento	Ciudad	Localización	Orden	Sector	Rama	Entidad Centralizada	Estado Contrato	Tipo de Contrato	Modalidad de Contratacion	Fecha de Firma	Fecha de Inicio del Contrato	Fecha de Fin del Contrato	Fecha de Inicio de Ejecucion	Fecha de Fin de Ejecucion	Condiciones de Entrega	TipoDocProveedor	Es Grupo	Es Pyme	Habilita Pago Adelantado	Liquidación	Obligación Ambiental	Obligaciones Postconsumo	Reversion	Valor del Contrato	Valor Facturado	Valor Pendiente de Pago	Valor Pagado	Valor Pendiente de Ejecucion	Saldo CDP	EsPostConflicto	Destino Gasto	Origen de los Recursos	Dias Adicionados	Nacionalidad Representante Legal	Género Representante Legal	Presupuesto General de la Nacion – PGN	Sistema General de Participaciones	Sistema General de Regalías	Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)	Recursos Propios	Fecha Inicio Liquidacion	Fecha Fin Liquidacion
2013134	MINISTERIO DE AGRICULTURA Y DESARROLLO RURAL	899999028	Distrito Capital de Bogotá	Bogotá	Colombia, Bogotá, Bogotá	Nacional	agricultura	Ejecutivo	Centralizada	En ejecución	Prestación de servicios	Contratación directa	2022-01-27	2022-01-28	2022-09-30	NaT	NaT	No Definido	Cédula de Ciudadanía	No	No	No	No	No	No	No	56933333	0	56933333	0	5.693333e+07	56933333	No	Inversión	Distribuido	0	COLOMBIANA	No Definido	56933333	0	0	0	0	NaT	NaT
298537	INSTITUTO PARA EL DEPORTE Y RECREACION DE YOPAL IDRY	800117801	Casanare	Yopal	Colombia, Casanare , Yopal	Territorial	deportes	Ejecutivo	Descentralizada	terminado	Prestación de servicios	Contratación directa	2022-09-08	2022-09-08	2022-12-22	NaT	NaT	A convenir	Cédula de Ciudadanía	No	No	No	No	No	No	No	5599965	0	5599965	0	5.599965e+06	5599965	No	Inversión	Distribuido	0	COLOMBIANA	Hombre	0	0	0	5599965	0	NaT	NaT
1825282	SANTIAGO DE CALI DISTRITO ESPECIAL DEPARTAMENTO ADMINISTRATIVO DE HACIENDA	890399011	Valle del Cauca	Cali	Colombia, Valle del Cauca , Cali	Territorial	Hacienda y Crédito Público	Corporación Autónoma	Centralizada	Cerrado	Prestación de servicios	Contratación directa	2022-01-14	2022-01-21	2022-06-30	NaT	NaT	No Definido	Cédula de Ciudadanía	No	No	No	No	No	No	No	21138000	0	21138000	0	2.113800e+07	2166366024	No	Inversión	Distribuido	0	colombiana	No Definido	0	0	0	21138000	0	NaT	NaT
830352	DEPARTAMENTO DEL META	8920001488	Meta	Villavicencio	Colombia, Meta , Villavicencio	Territorial	Servicio Público	Ejecutivo	Descentralizada	En ejecución	Prestación de servicios	Contratación directa	2023-05-25	2023-05-25	2023-10-29	NaT	NaT	Como acordado previamente	Cédula de Ciudadanía	No	No	No	No	No	No	No	24645000	0	24645000	0	2.464500e+07	24645000	No	Inversión	Distribuido	0	COLOMBIANA	Mujer	0	0	0	24645000	0	NaT	NaT
184407	ALCALDIA DE OCAÑA	890501102	Norte de Santander	No Definido	Colombia, Norte de Santander	Territorial	Servicio Público	Ejecutivo	Centralizada	terminado	Prestación de servicios	Contratación directa	2022-08-11	2022-08-11	2022-12-27	NaT	NaT	No Definido	Cédula de Ciudadanía	No	No	No	No	No	No	No	11040000	11040000	0	11040000	0.000000e+00	11040000	No	Inversión	Distribuido	0	COLOMBIANO	Mujer	0	0	0	11040000	0	NaT	NaT
296444	Secretaría Distrital de Integración Social	8999990619	Distrito Capital de Bogotá	No Definido	Colombia, Bogotá, Bogotá	Territorial	Inclusión Social y Reconciliación	Ejecutivo	Centralizada	Modificado	Prestación de servicios	Contratación directa	2022-07-27	2022-08-01	2023-02-26	NaT	NaT	Como acordado previamente	Cédula de Ciudadanía	No	No	No	No	No	No	No	17924500	17924500	0	17924500	0.000000e+00	17924500	No	Inversión	Distribuido	42	Colombiana	No Definido	0	17924500	0	0	0	NaT	NaT
1688630	MUNICIPIO DE MANIZALES	890801053	Caldas	Manizales	Colombia, Caldas , Manizales	Territorial	Servicio Público	Ejecutivo	Centralizada	En ejecución	Prestación de servicios	Contratación directa	2023-03-16	2023-03-16	2023-12-20	NaT	NaT	Como acordado previamente	Cédula de Ciudadanía	No	No	No	Si	No	No	No	21708439	0	21708439	0	2.170844e+07	25224590	No	Inversión	Distribuido	0	Colombiano	No Definido	0	21708439	0	0	0	NaT	NaT
1133493	ALCALDÍA LOCAL DE SUBA	899999061	Distrito Capital de Bogotá	Bogotá	Colombia, Bogotá, Bogotá	Territorial	Servicio Público	Ejecutivo	Centralizada	En ejecución	Prestación de servicios	Contratación directa	2023-05-15	2023-05-30	2023-08-29	NaT	NaT	Como acordado previamente	Cédula de Ciudadanía	No	No	No	No	No	No	No	12000000	4133333	12000000	0	1.200000e+07	12000000	No	Inversión	Recursos Propios	0	Colombiano	No Definido	0	0	0	0	12000000	NaT	NaT
1664830	REGIONAL DE ASEGURAMIENTO EN SALUD No 1	900336524	Distrito Capital de Bogotá	No Definido	Colombia, Bogotá, Bogotá	Territorial	defensa	Ejecutivo	Centralizada	Modificado	Prestación de servicios	Selección Abreviada de Menor Cuantía	2022-07-27	2022-08-03	2023-05-20	NaT	NaT	A convenir	No Definido	No	Si	No	Si	No	No	No	1018501884	0	1018501884	0	1.018502e+09	679001256	No	Funcionamiento	Distribuido	50	COLOMBIA	No Definido	849001256	169500628	0	0	0	NaT	NaT
1368108	GOBERNACION DEL MAGDALENA	800103920	Magdalena	Santa Marta	Colombia, Magdalena , Santa Marta	Territorial	No aplica/No pertenece	Ejecutivo	Centralizada	Suspendido	Obra	Licitación pública Obra Publica	2022-03-23	2022-06-13	2023-04-12	NaT	NaT	No Definido	No Definido	No	No	No	No	No	No	No	30042201653	0	30042201653	0	3.004220e+10	31436128789	No	Inversión	Distribuido	0	COLOMBIANO	No Definido	0	0	30042201654	0	0	NaT	NaT

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None